[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??
I saw where someone else had a similar problem and it was solved.
Are you referring to Excel’s “IF” formulas:confused: