Yes/No Function
 

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"

Yes/No Function
 

In J1 put

=IF(AND(ISNUMBER(H1),H1I1),"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(H1I1,"Yes","No")


--
Regards,

Peo Sjoblom

"dn5580" wrote in message
...
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"

Yes/No Function
 

You just gave the formula! ;) In cell J1, enter =IF(H1I1,"Yes","No")


On Apr 9, 9:22 am, dn5580 wrote:
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"

Yes/No Function
 

thanks for your help

" wrote:

You just gave the formula! ;) In cell J1, enter =IF(H1I1,"Yes","No")


On Apr 9, 9:22 am, dn5580 wrote:
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"