IF statement query

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
try this idea where you start with the highest
=if(d9>2901,62,if(d9>2501,60,58))
 
Your words say 2500 is not determined,
And you formula says 2501 is no determined.

Try this:

=IF(D9<2501,58,IF(D9<2901,60,62))

And post back if you need a revision.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

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
 
Back
Top