Thread: IF Question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default IF Question

=if(a1-b1=1,"One Under","Not One Under")

Regards,
Fred.

"Anthony" wrote in message
...
I have two colums of numbers and and how do I create a function that will
tell me if the one cloum is one less than the other.

Ex: Par Refill Point
2 1 One Under
5 3 Not One Under

Thanks