Excel's Nested If

To be filled by o.e.m. / To be filled by o.e.m.
July 23, 2009 at 12:57:10
Specs: Microsoft Windows XP Professional, 2.992 GHz / 1023 MB
Hi,

I have a problem with nested if.

1.) If value is greater than $150000., print "Platinum".
2.) If value is greater than $100000. print "Gold".
3.) If value is greater than $7500. print "Silver".
4.) If value is greater than $0. Print "Bronze".

This what I have so far:

=IF($B$1<150000, "Platinum", IF($B$1<100000, AND($B$1>150000, "Gold",IF($B$1<=75000,AND($B$1>100000, "Silver",IF($B$1<0,AND($B$1>75000, "Bronze")))))))

What am I missing?

I know what to do, I just don't know exactly what to do.

Thanks in advance,

wccc.pctutor


See More: Excels Nested If

Report •


#1
July 23, 2009 at 14:48:35
Try:

=IF(B1>150000,"Platinum",IF(B1>100000, "Gold",IF(B1>7500,"Silver",IF(B1>0,"Bronze",0))))

MIKE

http://www.skeptic.com/


Report •

#2
July 23, 2009 at 15:35:43
Hi,

Thank you! You are definitely the man. I was almost pulling my hair out. I was getting "Platinum" when it should have been "Gold", "Silver" or "Bronze". I changed it around and was still getting it wrong. I tried one "If" at a time and I was still getting the wrong text. I'm going to have to look your soluton over and try to make sense out of it. Again, you saved me from having to buy a tupee.

I really appreciate the time you took to reply.

Thank you!

wccc.pctutor


Report •

#3
July 23, 2009 at 15:44:33
You had it all prototyped, you just needed to remove some of the verbage:

1.) If value is greater than $150000., print "Platinum".
2.) If value is greater than $100000. print "Gold".
3.) If value is greater than $7500. print "Silver".
4.) If value is greater than $0. Print "Bronze".

1.) If(b1>$150000,"Platinum",
2.) If (b1>100000,"Gold"
3.) If (b1>7500,"Silver"
4.) If (b1>0,"Bronze",

add the final 0 for the FALSE response on the last IF and make sure you have the correct number of brackets.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
July 23, 2009 at 16:34:53
I thought I had to take into account the amount that fell between the less than and the greater than.

I had problems when I tried using just one If function. F2= $98,000. If F2 >75000, "Hi", "Bye" The printing of "Hi" had to be lie.

The problem is that this isn't my first time using an If function, in that case, using a lot of functions/formulas.

1.) If(b1>$150000,"Platinum",
If its less than?

It will make sense in the morning.

Thanks for coming back and explaining it!


Report •

#5
July 23, 2009 at 17:11:50
Glad I could help.

MIKE

http://www.skeptic.com/


Report •


Ask Question