Help with nested IF formula with at least 5 statements

Hi! I need help solving an excel formula equation. It is a nested IF with at least 5 different statements in it.

I think it may need a IF (AND) formula or perhaps a IF (OR) formula but I'm not sure why it is not working... I'm not sure, I'm getting a #NAME? Result.

=IF(A7>=2500000.01,Platinum,IF(A7>=1000000.01,Gold,IF(A7>=500000.01,Silver,IF(A7>=250000.01,Bronze,IF(A7>=100000.01,Copper,0)))))

I need the formula to quickly assign a level to hundreds of cells automatically, according to the following description:
Platinum $2,500,000.01 and Up
Gold $1,000,000.01 to $2,500,000
Silver $500,000.01 to $1,000,000
Bronze $250,000.01 to $500,000
Copper $100,000 to $250,000

This girl here is going crazy...

Thank you peeps!!! I really appreciate it.

Might also try a lookup

=IFERROR(LOOKUP(A7,{100000.01,250000.01,500000.01,1000000.01,2500000.01},{"Copper","Bronze","Silver","Gold","Platinum"}),0)

give this a try

=IFERROR(LOOKUP(A7/1000000,{0.1,0.25,0.5,1,2.5},{"Copper","Bronze","Silver","Gold","Platinum"}),"")

I think the lookup or vlookup solutions are the better way to go..
But should probably answer what was actually wrong with your original posted formula.
=IF(A7>=2500000.01,Platinum,IF(A7>=1000000.01,Gold,IF(A7>=500000.01,Silver,IF(A7>=250000.01,Bronze,IF(A7>=100000.01,Copper,0)))))

Nothing really wrong with the LOGIC of the formula, it's correclty written.
The problem is the values you're returning Platinum Gold etc...
If those are meant to be just returning as a text string, they need to have quotes around them.
So each of those values should be "Platinum" and "Gold" etc..

Oh the " " .... darn! I feel dumb!

But still no error now but now working... everything is defaulting to Platinum which is not right.

This one is returning a "blank" value.

I'm replying at the wrong places... sorry... everything is returning as Platinum with this.

Originally Posted by Ash_Maverick

=IF(A7>=2500000.01,"Platinum",IF(A7>=1000000.01,"Gold",IF(A7>=500000.01,"Silver",IF(A7>=250000.01,"Bronze",IF(A7>=100000,"Copper",0)))))

everything returned PLATINUM

Originally Posted by AlanY

give this a try

=IFERROR(LOOKUP(A7/1000000,{0.1,0.25,0.5,1,2.5},{"Copper","Bronze","Silver","Gold","Platinum"}),"")

This returned a BLANK cell

Originally Posted by eyork0401

This returned a BLANK cell

Yes! Thank you!!!! Love it!!!! I really appreciate it!

Originally Posted by Ash_Maverick

check this

It worked great for Platinum and Gold... silver is returning gold, copper is gold too. I copied and pasted the formula.

Originally Posted by eyork0401

It worked great for Platinum and Gold... silver is returning gold, copper is gold too. I copied and pasted the formula.

User error... i added a column and had to change the A7...

Originally Posted by eyork0401

User error... i added a column and had to change the A7...

Working!!!!!!!!!! Thanks bunches guys!!!!!!!!!!!!!!!!!!!!!!!