Rounding number down instead of up

I have a formula like so =SUM((A2-4)/4)^2*B2

I want answers to be in whole numbers but I need it to round down if the answer is .5 or less instead of rounding up. i.e. 12.50 would be rounded to 12 and not to 13. 12.51 would still round up to 13 though. Is this possible?

Thanks

Try;

Formula:

Please Login or Register  to view this content.

Or try:

=ROUND(your formula-0.01,0)

Originally Posted by Phuocam

Or try:

=ROUND(your formula-0.01,0)

Thank you, this worked once I added the 0.01 to the formula.