Here are some problems that our users have asked and received explanations on
If a calculated cell is less than 0 = 0, if the same cell is greater that 0 that multiplied by 12
a1:a4 if greater than zero a5 x 12 if a5 is less than 0 = 0
Solved by G. H. in 21 mins
if K2 is less than 0, then I2. But if greater than 0, then K2(or leave as it is)
Solved by E. S. in 26 mins
If cell f16 is greater than 0 them multiply the total by 102 and subtract 127.5.
Solved by B. Y. in 16 mins
=IF(AND(D11>0,F11>0)(D11^2+F11^2)^.5)0)
if cell D11is greater than 0 AND F11> 0 then D11^2+F11^2)^.5)0 else 0
Solved by S. A. in 27 mins
I'm trying to get a count of the difference where the difference is greater than and less than in column E. I tried an if, then using greater than 0 but it's not working properly for me.