New to formulas

[Rickat86]

Hi, I'm new to formulas and I can't figure out what I am doing wrong, please help!

If cell J59 is greater then G59, N59 needs to say "Fail", if less "Pass". But if G59 is blank, N59 needs to say "N/A".

I tried these formulas but excel doesn't like them, what am I doing wrong? 

=IF(ISBLANK(G59),"N/A",J59>G59,"Fail","Pass)

=if(isblank(G59),"N/A",(J59>G59,"Fail","Pass"))

[#2]

@Rickat86 Perhaps like this in N59:

=IF(G59="","N/A",IF(J59>G59,"Fail","Pass"))

[#3]

That works thanks, is it possible to have it that if either G59 or J59 is blank, then N59 says "N/A"

[#4 · Accepted solution]

@Rickat86 That would be:

=IF(OR(J59="",G59=""),"N/A",IF(J59>G59,"Fail","Pass"))

[#5]

Thank you :folded_hands: