=IF(F5<1799,87,IF(AND(F5=1800,F5<=2499),116,170))

HTH
Jason
Atlanta, GA

-----Original Message-----
I need to write a nested 'if' stating something like
this:
=IF((F5<1799),"87",IF(F5 between 1800and2499),116,170)
I am unsure of the between tis number and that number
bit.

All help appreciated

tia
--
Jock Waddington
.