Rounding formula for when 0 to 0.54 rounds down, and 0.55 to 1 rounds up

[thefallofrome]

My formula is =(9/0.72)=12.50

I would like this value to be rounded down to 12 instead of rounding up to 13. However, the formula I need has to meet the following criteria, where 0 to 0.54 rounds down and 0.55 to 1 rounds up.

Any help will be great because I am having trouble with this one.

Thank you.

[AliGW]

This is what the ROUND function does!

=ROUND(your_formula,2)

This rounds to 2 decimal places.

[thefallofrome]

This is what the ROUND function does!

=ROUND(your_formula,2)

This rounds to 2 decimal places.

Thank you for your response. I tried the following but the result I want must be rounded to a whole number.

[Phuocam]

Try this:

=ROUND(A1-0.05,0)

[thefallofrome]

Try this:

=ROUND(A1-0.05,0)

This makes sense. Thank you very much!