Help..is it possible to....

[M17RVX]

create a formula in a cell which looks at another cell and depending on the value of the cell, output one of 5 values
Forgive my terminology, but please can you help me.
I want to create a formula that will lookup a cell and depending on the value of the cell round down to the nearest 25%
EG:
Cell = 0 to 24 iI want to return a value of 0
Cell = 25 to 49 I want to return a value of 25
Cell = 50 to 74 I want to return a value of 50
Cell = 75 to 99 I wants to return a value of 75
Cell = 100 or more I wants to return a value of 100

Thank you in anticipation

 

[Fluff]

How about
=IF(A2<125,FLOOR(A2,25),100)

 

[M17RVX]

How about
=IF(A2<125,FLOOR(A2,25),100)

WOW! Thank you #mindblown ?

 

[Fluff]

You're welcome & thanks for the feedback