G
Guest
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(D9>2501,60),IF(D9>2901,62))
which returns 60, even when d9 = 2910
obviously doing something wrong, but not sure what.
any help would be appreciated.
thanks
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(D9>2501,60),IF(D9>2901,62))
which returns 60, even when d9 = 2910
obviously doing something wrong, but not sure what.
any help would be appreciated.
thanks