IF formulas

[chrisj]

I am fairly new to Excel IF formulas and need help in displaying a result in one cell depending on the value in another cell. Something I am sure should be easy to do but I cannot get it to work.

Eg if A1 is greater or less than 10 display 100. If A1 is => than 50 multiply A1 by 25, If A1 is => than 100 multiply by 20 If A1 is =>250 multiply by 17

Would much appreciate some guidance on this.
Thanks in advance

[Audiojoe]

Hey there, try this:

=IF(A1>=250,A1*17,IF(A1>=100,A1*20,IF(A1>=50,A1*25,IF(A1=10,10,100))))

Hope it's what you want

[Mark W.]

On 2002-04-17 04:28, chrisj wrote:
I am fairly new to Excel IF formulas and need help in displaying a result in one cell depending on the value in another cell. Something I am sure should be easy to do but I cannot get it to work.

Eg if A1 is greater or less than 10 display 100. If A1 is => than 50 multiply A1 by 25, If A1 is => than 100 multiply by 20 If A1 is =>250 multiply by 17

Would much appreciate some guidance on this.
Thanks in advance

Chris, your specification is ambiguous...

1. If A1 <> 10 then display 100
2. If A1 >= 50 then A1*25
3. If A1 >= 100 then A1*20
4. If A1 >= 250 then A1*17

Okay, suppose A1 is 250. All 4 of the above conditions are TRUE! What should be displayed? 100? A1*25? A1*20? A1*17?