please help! my brain isnt brain-ing today

[LIZEEY]

i need to create a formula that will return me different value based on percentage met ie; under 90% = 1 / 90-95% = 2 / 95-100% = 5 / 100+% = 10 my mind is a complete blank1 i have tried IF/AND but just cant get it to work for all 4 scenarios -( please help

 

[LIZEEY]

HOLD ON!

I just noticed a typo in your formula:

=IF(AI16>=100%,2,IF(AI16>=95%,1,IF(AI1>=90%,0.5,IF(AI16<90%,0,0))))

I believe the part in red should also be "AI16"

its been a very long day! lol thanks for your help