Formula Result "" still registers as a number??

[alag76]

Hi,

I have a the following formula in a spreadsheet =IF(G39="","",(TODAY()-G39)) but the "" result is causing issues for me in a formula in another cell where if G39>120 then an X should be populated. Although G39 is blank the other cell is still populating as if G39>120. Thanks in advance for any help.

 

[godsaaint]

Can you post the other formula? In what cell do you have "=IF(G39="","",(TODAY()-G39))"?

 

[JoeMo]

Hi,

I have a the following formula in a spreadsheet =IF(G39="","",(TODAY()-G39)) but the "" result is causing issues for me in a formula in another cell where if G39>120 then an X should be populated. Although G39 is blank the other cell is still populating as if G39>120. Thanks in advance for any help.

What's the formula in the other cell?

 

[alag76]

Can you post the other formula? In what cell do you have "=IF(G39="","",(TODAY()-G39))"?

The other formula is:
=IF(AND($K39="",$I39>=120),"x",IF($K39>=120),"x",""))

The first formula is in cell I39.

K39 has this formula: =IF(J39="","",(TODAY()-J39))

Thank you!

 

[Tetra201]

Try this:

=IF(AND($K39="",--(0&$I39)>=120),"x",IF(--(0&$K39)>=120,"x",""))