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

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

MIKE

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

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

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!

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History