conditional formulas

  • Thread starter Thread starter Rasoul Khoshravan
  • Start date Start date
R

Rasoul Khoshravan

remove qoutation marks. With them, Excel treat whatever inside as text not
as sum command.
 
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?
 
Just omit quotation marks:
=IF(G12>0,sum(d12+f12)-g12, "")

Regards,
Stefi

„Ms Cranky†ezt írta:
 
That's perfect. Thanks.

Stefi said:
Just omit quotation marks:
=IF(G12>0,sum(d12+f12)-g12, "")

Regards,
Stefi

„Ms Cranky†ezt írta:
Click to expand...
 
You are welcome! Thanks for the feedback!
Stefi

„Ms Cranky†ezt írta:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I edit the formula without changing the format? {=SUM(if. 1
when striking qoutation mark nothing appears until hit space bar 2
How can I use the * wildcard in an array formula 4
Bug with Excel 2003 saving as Tab Delimmited Text 5
Excel ignore formula 8
Conditional formatting a cell containing "<" 4
Conditional Formatting 1
Conditional Formatting Problem 7

Back
Top