Nested IF statements

[oneblondebrow]

Hi all,

Please in attached at test sheet, I a using an older version of Excel so unfortunate not able t use =IFS but only nested I statements but cannot get it to work, I fact the more I try the worse I seem to be make it

What I am trying to do is, In COLUMN C use multiple nested IF statements to determine what tier a person falls under in regards to a number, So for instance is somone gets 18600 then they would b in TIER 2, If someone else gets only 9999 then they will be in Tier 0 and so on (as on the test sheet attached)

Am I right in trying a Nested IF statement to do this? if so any idea's on how I can

Thank you in advance for any help.

[Fluff13]

If you change the Tier0 value to 0 you can use this
=INDEX($F$4:$F$10,MATCH(B2,$G$4:$G$10,1))

[oneblondebrow]

If you change the Tier0 value to 0 you can use this
=INDEX($F$4:$F$10,MATCH(B2,$G$4:$G$10,1))

Thanks for the reply, It doesn't work, I get he N/A error, Is this because it's trying to MATCH an exact amount?

Tier 1 would be any number from 0 - 9999, Tier 2 10000 - 14999, Tier 3 15000 - 19999 and so on, Sorry that's my fault I did not explain it very well.

[Fluff13]

As long as the ratings in G4:G10 are the minimum rating for the tier it should work.