Hi,

=ABS(B1-A1)&IF(B1<A1," Under"," Over")

but more likely:

=IF(B1<A1,A1-B1&" Under",IF(B1A1,B1-A1&" Over",""))&" Par"

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Anthony" wrote:

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