"IF" formula

I have an IF formula delima!!

I have 2 columns

in the B column if the cell = 0 then I need to multiply the figure in the adjacent A column by 30% to equal the appropriate figure in column B

=IF(B2:B6722)=0, then what??

any help

I saw where someone else had a similar problem and it was solved.

thanks

I don’t understand your explanation on what cells (columns) contain the zeroes and which cells should be multiplied, and where you need the result.

Could you please be more specific?

Welcome to CDFreaks! :slight_smile:

[QUOTE=ladyjessieb;2228360]I have an IF formula delima!!

I have 2 columns

in the B column if the cell = 0 then I need to multiply the figure in the adjacent A column by 30% to equal the appropriate figure in column B

=IF(B2:B6722)=0, then what??

any help

I saw where someone else had a similar problem and it was solved.

thanks[/QUOTE]

Are you referring to Excel’s “IF” formulas:confused:

Sounds like Excel,
I am just getting into the simple stuff myself hope to see the answer here so I know how it’s done

[QUOTE=bean55;2229103]Sounds like Excel,
I am just getting into the simple stuff myself hope to see the answer here so I know how it’s done[/QUOTE]

This should help:D

http://www.ozgrid.com/Excel/free-training/basic-index.htm