conditional formulas
I want to apply a condition which displays the result of a formula when a
cell value 0 and if cell value =0 then I want it to display as blank. I
tried =IF(G120,"sum(d12+f12)-g12", "") but whilst this displays a blank if
cell value =0 it displays the formula as written if value is 0.
Can anyone help?
|