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