software

Does Excel have the ability to calculate the followingquot;

I have a calculated value in cell A51.

If that calculated value is in the range of numbers in the first column
below, I need a formula for Excel to return the value in the second column
below to cell A60.

0 - 500,000 250
500,001 -750,000 300
750,001 - 1,000,000 350
1,000,001 - up 400

Any help is greatly appreciated.

Try something like this:

With this:
________Col_A______Col_B
Row_1___0_________250
Row_2___500,001___300
Row_3___750,001___350
Row_4___1,000,001__400

And a value in A51
A60: =VLOOKUP(A51,A1:B4,2,1)Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;cindybquot; wrote:

gt; Does Excel have the ability to calculate the followingquot;
gt;
gt; I have a calculated value in cell A51.
gt;
gt; If that calculated value is in the range of numbers in the first column
gt; below, I need a formula for Excel to return the value in the second column
gt; below to cell A60.
gt;
gt; 0 - 500,000 250
gt; 500,001 -750,000 300
gt; 750,001 - 1,000,000 350
gt; 1,000,001 - up 400
gt;
gt; Any help is greatly appreciated.

No need for that, use lookup

=LOOKUP(A51,{0;500001;750001;1000001},{250;300;350 ;400})

if A51 can be blank you might want to use

=IF(A51=quot;quot;,quot;quot;LOOKUP(A5,{0;500001;750001;1000001},{ 250;300;350;400}))

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;cindybquot; gt; wrote in message
...
gt; Does Excel have the ability to calculate the followingquot;
gt;
gt; I have a calculated value in cell A51.
gt;
gt; If that calculated value is in the range of numbers in the first column
gt; below, I need a formula for Excel to return the value in the second
gt; column
gt; below to cell A60.
gt;
gt; 0 - 500,000 250
gt; 500,001 -750,000 300
gt; 750,001 - 1,000,000 350
gt; 1,000,001 - up 400
gt;
gt; Any help is greatly appreciated.One way, via VLOOKUP

Put in A60:
=IF(OR(A51=quot;quot;,A51lt;=0),quot;quot;,VLOOKUP(A51,{0,250;500001 ,300;750001,350;1000001,40
0},2))

The above VLOOKUP carries a quot;standalonequot; table_array, so we don't need to
reference the table elsewhere. The IF error traps will ensure that a neat
looking blank: quot;quot;, is returned (instead of ugly #N/As).
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;cindybquot; gt; wrote in message
...
gt; Does Excel have the ability to calculate the followingquot;
gt;
gt; I have a calculated value in cell A51.
gt;
gt; If that calculated value is in the range of numbers in the first column
gt; below, I need a formula for Excel to return the value in the second
column
gt; below to cell A60.
gt;
gt; 0 - 500,000 250
gt; 500,001 -750,000 300
gt; 750,001 - 1,000,000 350
gt; 1,000,001 - up 400
gt;
gt; Any help is greatly appreciated.
quot;cindybquot; wrote:
gt; I have a calculated value in cell A51.
gt; If that calculated value is in the range of numbers in the
gt; first column below, I need a formula for Excel to return
gt; the value in the second column below to cell A60.
gt; 0 - 500,000 250
gt; 500,001 -750,000 300
gt; 750,001 - 1,000,000 350
gt; 1,000,001 - up 400

Others have suggested a lookup function, which arguably
might be the best approach. If you still prefer an IF()
function, this particular example is not too bad:

=IF(A51 lt;= 500000, 250,
IF(A51 lt;= 750000, 300, IF(A51 lt;= 1000000, 350, 400)))Thanks so much for your help! It works!!

quot;cindybquot; wrote:

gt; Does Excel have the ability to calculate the followingquot;
gt;
gt; I have a calculated value in cell A51.
gt;
gt; If that calculated value is in the range of numbers in the first column
gt; below, I need a formula for Excel to return the value in the second column
gt; below to cell A60.
gt;
gt; 0 - 500,000 250
gt; 500,001 -750,000 300
gt; 750,001 - 1,000,000 350
gt; 1,000,001 - up 400
gt;
gt; Any help is greatly appreciated.