IF statement query
 

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

IF statement query
 

try this idea where you start with the highest
=if(d92901,62,if(d92501,60,58))

--
Don Guillett
SalesAid Software

"shakey1181" wrote in message
...
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

IF statement query
 

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!
================================================== ===

"shakey1181" wrote in message
...
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