yes,no,even,formula

[John Caines]

Hello All.
Trying to write a simple (But not for me ) formula.
All I want to say is;
IF J5=H19,, show the word "EVEN
If J5 is greater than H19 shoe the word "YES"
If J5 is less than H19 show the word "NO

Originally I had;

=IF(J5="","",IF(J5>$H$19,"YES","NO")

But now I want to add the word even into it,, just can't seem to get it
I have now (But it doesn't work;

=IF(J5="","",IF(J5>$H$19,"YES","NO"),IF(J5=$H$19,"EVEN"))

Can anybody show me the error please?
I can't be far off
Many thanks;
John Caines

 

[MrKowz]

Try:

=IF(J5="","",IF(J5=H19,"EVEN",IF(J5>H19,"YES","NO")))

 

[Joe4]

=if(j5="","",if(j5>$h$19,"yes",if(j5=$h$19,"even","no")))

 

[John Caines]

Excellent!!!!!
Working!
Many thanks to you both,,,,
I wasn't too far off,, but that doesn't stick with excel

Many thanks again
Best regards
A very happy
John Caines