All,

Trying to write a formula which returns a value depending on the value of
another cell. So if d9 is less than 2500 then return 58, if between 2501 and
2900 then 60 and if 2900+ then 62. The best I have come up with is:

=IF(OR(D9<2501,58),IF(D92501,60),IF(D92901,62))

which returns 60, even when d9 = 2910

obviously doing something wrong, but not sure what.

any help would be appreciated.

thanks