Forum Discussion
need help with a formula
how do i make a formula for :
If (cell1) = 0, then use (cell2)* (cell4); otherwise, use (cell1)*(cell4)
That would be something like this:
=IF(A1=0,A2*A4,A1*A4)
BUT, when A1 is not equal to 0 then A1*A4 would also be zero. What it it the you actually want to achieve when A1 is not equal to 0?
