Showing a word based on results

[Drasston369]

I feel a bit blonde posting this. But I need an if statement and can't quite get it right.
I want it to calculate a percentage then show a word based on the result.

So there will be 4 words.
If a2 is less than 90% of a1 then the word will show "Bronze"
if a2 is 90-90% of a1 then the word will show "Silver"
if a2 is 100-109% of a2 then the word will show "Gold"
if a2 is greater than a1 then the word will show "Platinum"

I'm having trouble with getting the ranges correct.

So ideally
if A2=80 and A1 is 100 then A3 will show "Bronze".
if A2 was 95 and A1 is 100 then A3 will show "Silver"
if A2 is 104 and A1 is 100 then A3 will show "Gold"
if A2 is 140 and A1 is 100 then A3 will show "Platinum"

Thanks guys

 

[NiMip]

I feel a bit blonde posting this. But I need an if statement and can't quite get it right.
I want it to calculate a percentage then show a word based on the result.

So there will be 4 words.
If a2 is less than 90% of a1 then the word will show "Bronze"
if a2 is 90-99.99...% of a1 then the word will show "Silver"
if a2 is 100-109.99...% of a1 then the word will show "Gold"
if a2 is greater than a1 then the word will show "Platinum"

I'm having trouble with getting the ranges correct.

So ideally
if A2=80 and A1 is 100 then A3 will show "Bronze".
if A2 was 95 and A1 is 100 then A3 will show "Silver"
if A2 is 104 and A1 is 100 then A3 will show "Gold"
if A2 is 140 and A1 is 100 then A3 will show "Platinum"

Thanks guys

Hey, I think I know what you're asking but your description doesn't quite match what I'm picturing. I've made some changes in red above to reflect what I think you're after, so apologies if I've misunderstood.

The following nested IF statement should work: =IF(A2/A1<0.9,"Bronze",IF(A2/A1>=1.1,"Platinum",IF(A2/A1>=1,"Gold","Silver")))

 

[NiMip]

Sorry I also meant to change the last statement too. My solution is actually providing the following:

If a2 is less than 90% of a1 then the word will show "Bronze"
if a2 is 90-99.99...% of a1 then the word will show "Silver"
if a2 is 100-109.99...% of a1 then the word will show "Gold"
if a2 is greater than or equal to 110% of a1 then the word will show "Platinum"

 

[BrianJN1]

You have a few issues in how you wrote up your specifications. I think my formula has interpreted what you require, at least it appears to fulfill what your ideal is:
=IF(A2 < A1*0.9,"Bronze",IF(AND(A2 > A1*0.89,A2 < A1*1),"Silver",IF(AND(A2 > A1*0.99,A2 < A1*1.1),"Gold",IF(A2 > A1,"Platinum",""))))<a1*0.9,"bronze",if(and(a2><a1*1),"silver",if(and(a2><a1*1.1),"gold",if(a2><a1*0.9,"bronze",if(and(a2><a1*1),"silver",if(and(a2><a1*1.1),"gold",if(a2><a1*0.9,"bronze",if(and(a2><a1*1),"silver",if(and(a2><a1*1.1),"gold",if(a2>
Note that I've converted % to decimals.

</a1*1.1),"gold",if(a2></a1*1),"silver",if(and(a2></a1*0.9,"bronze",if(and(a2></a1*1.1),"gold",if(a2></a1*1),"silver",if(and(a2></a1*0.9,"bronze",if(and(a2></a1*1.1),"gold",if(a2></a1*1),"silver",if(and(a2></a1*0.9,"bronze",if(and(a2>

 

[Drasston369]

That's perfect! Thanks!