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.