Hi

The formula originally posted by Bernd
=IF(D4<=50,2000,IF(D4<100,5000,10000))
or the response from Ron of
=CHOOSE(MIN(CEILING((N(D4)+(N(D4)=100))/50,1),3)+1,0,2000,5000,10000)

each produce the result as per your specification, provided you are
entering valid numbers in cell D4
If you are not getting the correct result, you either have not copied
the formulae exactly as posted, or your data entered is incorrect.

--
Regards

Roger Govier


"Excel Confused" wrote in
message ...
It shows $0.00 and does not change when I enter a different number in
D4.
Unfortuantely this did not help. I really think it is an IF problem
though.
So If D4 is a number from 1 through 50 I need B3 to display $2,000.
And If
D4 is a number from 50 through 100 I need B3 to display $5,000
instead. And
If D4 has a number greater than 100 I need B3 to display $10,000.

D4 will have a different number entered every time I use my workbook,
it is
just a cell I put a number into. B3 needs to give me only one of
three
answers no matter what number D4 contains based on the ranges stated
above,
B3 needs to show me $2,000, $5,000 or $10,000 only
--
Please help out a moderate excel user


"Ron Coderre" wrote:

Maybe something like this:

With
D4: any value, including text (but not an error)

E4:
=CHOOSE(MIN(CEILING((N(D4)+(N(D4)=100))/50,1),3)+1,0,2000,5000,10000)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Excel Confused" wrote:

Hi , thanks for the reply. I unfortuantely have not got a solution
just yet.
Let me rephrase my problem:
D4 is a cell I will enter different numbers into every time I use
this
workbook. If I enter a number from 1 through 50 in D4, I would
like the cell
I am entering the formual into to display $2,000. If I enter 50
through 100
in D4 I need the cell I am entering the same formula into to
display $5,000.
If I enter 100 or greater in D4 I need the cell I am entering the
same
formula into to display $10,000. There are two cells in total, one
is D4 the
data entry cell that could contain any number and the other is the
cell that
should display the relevant answer, which is one of three answers
as stated
above i.e. $2,000, $5,000 or $10,000 based on the number entered in
cell D4.
HTH Help Me. Thanks for your help on this one.
--

--
Please help out a moderate excel user


"Ron Coderre" wrote:

Try something like this:

With
A1: (a number)

B1:
=CHOOSE(MIN(CEILING((A1+(A1=100))/50,1),3)+1,0,2000,5000,10000)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Excel Confused" wrote:

I am trying to solve this problem:

If a value in cell D4 is from 1 to 50 then I want a certain
celll to show
$2000 if the value in cell D4 is 50 to 100 then I want that
certain cell to
show $5000 instead, and if the value in cell D4 is greater than
100 then I
want to show $10000 instead.

Seems pretty simple here is my logic, It just says formula
error??? Please
help
IF((D4<=50,"2000",""),IF(D450<100,"5000",""),IF(D 4=100,"10000",""))
--
Please help out a moderate excel user