Sep 15 2023 09:06 AM - edited Sep 15 2023 09:14 AM
how do i make a formula for :
If (cell1) = 0, then use (cell2)* (cell4); otherwise, use (cell1)*(cell4)
Sep 15 2023 09:34 AM
@jerrygvanwykepccom
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?
