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
