If Formula not returning correct number

[Badnames]

Hey I have the following if formula:

=IF(G18=" ",0,ECS!$FJ$129)

It references a list in G18. When the list is blank I want it to return 0, but when it is populated I want it to return the value in FJ129. Currently it is always returning 0 in the cell, no matter what G18 is. If I change the formula to the below it always returns FJ129 value of 75. How can I have it correctly differentiate between a blank and a nonblank?

=IF(G18="",0,ECS!$FJ$129)

 

[Aladin Akyurek]

What do you have in G18 exactly?

 

[Badnames]

Actually my problem was auto calculate was not on. Just hit f9 and everything refreshed correctly. G18 was a drop down list. There were two options, one is a text, the other is blank cell.


I needed to remove the space in the quotes and now its differentiating properly between the blank and non-blank. Just needed to hit f9 to refresh.

 

[Aladin Akyurek]

Actually my problem was auto calculate was not on. Just hit f9 and everything refreshed correctly. G18 was a drop down list. There were two options, one is a text, the other is blank cell.


I needed to remove the space in the quotes and now its differentiating properly between the blank and non-blank. Just needed to hit f9 to refresh.

Ok. Thanks for providing feedback.