Empty Cell shows 0 1

[jatolo]

Hi!!!
quick question.. this formula is working great the only thing is; if G36 y G37 are empty I'd like to see an empty cell instead 0.


=IF(G36>G37,"A",IF(G36<G37,"B",IF(G36=G37,"C")))

thanks...G36:G37="",""?????? iS THIS GOOD
Thanks

 

[SkipVought]

[tt]
=IF(and(isempty(G36),isempty(G37)),"",IF(G36>G37,"A",IF(G36<G37,"B",IF(G36=G37,"C"))))
[/tt]


Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[zahead31]

You are on the right track... try this and see if it meets your need:

=IF(G36>G37,"A",IF(G36<G37,"B",IF(G36=G37,IF(AND(G36="",G37=""),"","C"))))

Hope this helps,
Matt

 

[zahead31]

Looks like Skip beat me to it (and with a better solution)!

I learned something too, because I did not know about the ISEMPTY function... one question for you, Skip. I am using Excel 2003 and I am able to find the ISBLANK function, which appears to do the same thing. I am unable to find ISEMPTY... is this a built in function that may have had its name changed?

By the way, star for you for introducing that function to me, whatever it is named!

 

[jatolo]

I guess... I'm doing something wrong, It's giving the following error

##name? Why is that?
=IF(AND(isempty(G36),isempty(G37)),"",IF(G36>G37,"A",IF(G36<G37,"B",IF(G36=G37,"C"))))

 

[SkipVought]

Sorry, it should be ISBLANK instead of isempty.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}