Nested If statements

[Excel for President]

I am currently struggling with a formula I have in my excel. There is a number in cell F11 that is between 1 and 5 (it varies based on the information entered). I am trying to write a formula that will say if the number is less than 2, then say Bronze. If it is 2-3, then say Silver. If it is 3-4 then say Gold. Finally, if it is greater than 4, then say Platinum. I've tried using: =IF(F11>4,"Platinum",=IF(F11>3,"Gold",=IF(F11>2,"Silver",=IF(F11>1,"Bronze",0)))) and =IF(F11<2,"Bronze",=IF(AND(F11>2,F11<3),"Silver",=IF(AND(F11>3,F11<4),"Gold",=IF(F11>4,"Platinum")))) but had no luck with neither formula. I thought both formulas would work but apparently I was sadly mistaken. Is there something I'm missing? Any help is much appreciated!

 

[tygrrboi]

Your original formula should work as well if you remove all the = signs

=IF(F11>4,"Platinum",IF(F11>3,"Gold",IF(F11>2,"Silver",IF(F11>1,"Bronze",0))))

 

[Excel for President]

Awesome! I got the formula to work by removing the equal signs. Thank you for your help! I am going to have to remember that. Such a silly mistake.