Rounding off a number to minimum

[Jaywardhan]

Hi All,

I am trying to round off a number to a minimum value, for example if i round off 2.40 by using the formula =Round() it will give me 2 however if i round off 2.50 it is giving me 3.

I am not able to figure out any way to round off numbers more then 2.5 so that they should me give a result as 2.

Please help.

Regards,
Jay.

 

[btadams]

Have you tried the RoundDown function?

 

[barry houdini]

If you want to rounddown to the nearest integer there are several ways.....ROUNDDOWN as sugested or perhaps

=FLOOR(A1,1)

or

=INT(A1)

 

[Jaywardhan]

oh was that so easy??..... Thanks a lot.

 

[Scott Huish]

If you will have negative numbers, you will want to use the INT formula.

ROUNDDOWN and FLOOR (with formula modification) don't round down negative numbers, they round them up.

 

[Scormell]

Hi All,

I am trying to round off a number to a minimum value, for example if i round off 2.40 by using the formula =Round() it will give me 2 however if i round off 2.50 it is giving me 3.

I am not able to figure out any way to round off numbers more then 2.5 so that they should me give a result as 2.

Please help.

Regards,
Jay.

What I have found helpful in the past when i have multiple calculations that i am trying to put into a formula is to perform each function separately in hidden cells then link to the final answer of those functions in the cell i am working with. i recently created a calculator to calculate the time a job operation took based on the size of the part. being for a quoting process i wanted to work with a 1 minute minimum and whole numbers after that. i started with round up "=roundup([cell],0)" (the 0 here indicates decimal places, 0 gives whole number, 1 gives .x, 2 gives .xx and so forth) based on 1 min per square foot. but was finding that at 1.0001 square feet it right away bumped to 2 minutes. so performed my calculation in a hidden cell, then performed my minimum of 1 minute function with a if/then formula "=IF([first calculation cell]<1,1, [hidden cell performing round function])". result is, if my time calculation is less than 1 minute, it returns the 1 minute minimum, but if the time result is greater than 1, it rounds the number up or down to a whole number there by giving me a more accurate time estimate.

hopefully some one finds this useful, i have been helped so many times from this and other similar boards, its nice to be able to give back every now and then.

Scott