conditional formulas
That's perfect. Thanks.
"Stefi" wrote:
Just omit quotation marks:
=IF(G120,sum(d12+f12)-g12, "")
Regards,
Stefi
€˛Ms Cranky€¯ ezt Ć*rta:
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?
|