G
Guest
Looking to get a formula for the following scenerio:
if H1 is greater than I1, then J1 is "Yes" and of not J1 is "No"
if H1 is greater than I1, then J1 is "Yes" and of not J1 is "No"
P
Peo Sjoblom
In J1 put
=IF(AND(ISNUMBER(H1),H1>I1),"Yes","No")
if you are 100% sure H1 can never be text (text is always greater than
numbers in Excel) you can simplify to
=IF(H1>I1,"Yes","No")
=IF(AND(ISNUMBER(H1),H1>I1),"Yes","No")
if you are 100% sure H1 can never be text (text is always greater than
numbers in Excel) you can simplify to
=IF(H1>I1,"Yes","No")
O
omnicrondelicious
You just gave the formula! 
In cell J1, enter =IF(H1>I1,"Yes","No")
In cell J1, enter =IF(H1>I1,"Yes","No")
G
Guest
thanks for your help
[email protected] said:You just gave the formula!