R
Rasoul Khoshravan
remove qoutation marks. With them, Excel treat whatever inside as text not
as sum command.
as sum command.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Ms Cranky
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(G12>0,"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?
cell value >0 and if cell value =0 then I want it to display as blank. I
tried =IF(G12>0,"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?
S
Stefi
Just omit quotation marks:
=IF(G12>0,sum(d12+f12)-g12, "")
Regards,
Stefi
„Ms Cranky†ezt Ãrta:
=IF(G12>0,sum(d12+f12)-g12, "")
Regards,
Stefi
„Ms Cranky†ezt Ãrta:
M
Ms Cranky
That's perfect. Thanks.
Stefi said:Just omit quotation marks:
=IF(G12>0,sum(d12+f12)-g12, "")
Regards,
Stefi
„Ms Cranky†ezt Ãrta:
S
Stefi
You are welcome! Thanks for the feedback!
Stefi
„Ms Cranky†ezt Ãrta:
Stefi
„Ms Cranky†ezt Ãrta: