How can I use If Statement with different ranges and specific answers?

Could you please help me with this problem?
I have tried to explain required formula in simple language.


IF C52 is between 0 & 10000 then G52=0,

IF C52 is between 10000 & 15000 then G52=5,

IF C52 is bwtween 15000 & < 22500 then G52=7.5,

IF C52 is >22500 then G52=10

Try

=LOOKUP(C52,{0,10000,15000,22500},{0,5,7.5,10})

thanks it works

You're welcome. Please remember to mark your thread as SOLVED (see instructions in rule #9 by clicking Forum Rules @ top of page).