Thanks Problem Solved. I used Bernd's Formula and I was not referencing the
wrong cell as the cell D4 was on another sheet. Sorry about the confusion.
Really appreciate the help
--
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