Can I create an if formula to round decimals with differents statements?

Question

I'm having trouble trying to create the formula to round numbers with an if function. I need to round decimals between 5 different statements:

• If a number has decimals between 0.1 and 0.5 rounddown to 0.
• If a number has decimals between 0.6 and 0.29 round to 0.25.
• If a number has decimals between 0.30 and 0.55 round to 0.50.
• If a number has decimals between 0.56 and 0.80 round to 0.75.
• If a number has decimals between 0.76 and 0.99 round to 1.

Answer 1

Use ifs(), like this:

=ifs( 
  A2 < 0.01, na(), 
  A2 <= 0.05, 0, 
  A2 <= 0.29, 0.25, 
  A2 <= 0.55, 0.5, 
  A2 <= 0.8, 0.75, 
  A2 <= 1, 1, 
  true, na() 
)