the greater than and less than if statement

[darkwarrior]

HI guys I am new here so here goes, if i wanted to use the if statement to indicate if a column is greater than another columnsay by 10 show 'yes' and if it is less than 10 show 'no' how would i do this?
Thnax for your help!!

 

[Oorang]

=IF(A1+10>A2,"Yes","No")

 

[darkwarrior]

Thanx!! really appreciate this great.

 

[darkwarrior]

I however made a tiny mistake...i should have included the or equal to statement ..so here i go again 'if the number is greater than or equal to 10 show yes if the number is less than or equal to show no..sorry for the mix up and thanks for any additional help!!

 

[a7n9]

May be this:

=if(A1>=10,"Yes","NO"))

I must be sleeping when I had another if. lol. Sorry

 

[darkwarrior]

Hey Thanks Man !! that hits the nail on the proverbial head!! that worked remarkably well !! thanks a million!.

 

[Brian from Maui]

May be this:

=if(A1>=10,"Yes",if(A1<=10,"NO"))

No need for the second IF

=IF(A1>=10,"Yes","No")

 

[Scott Huish]

You really shouldn't have equal to in both parts, you can't do both if it is equal.

So if you wanted YES if it was greater than or equal to 10, and NO if not:

=IF(A1>=10,"Yes","No")

 

[darkwarrior]

Well hotpepper, it did work even with the double closed brackets!

 

[Scott Huish]

It works because the first condition was met, but you don't need it.