Great, that formula did it...Thanks so much!

FSt1 wrote:
hi
try this..
=IF(R29=T29,"OK",IF(AND(R29-T29-1,R29-T29<1),"OK","Off by
$"&ROUND(R29-T29,0)))

regards
FSt1

What formula do I use if I'd like to use the if formula but set the criteria
between 2 values? Below is my example.
[quoted text clipped - 6 lines]
between 1 and -1? Please let me know if there is a way to modify this
formula.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200812/1