=ROUND(H10*(1/H6),0)/(1/H6)

Where

- H10 holds the value that you are rounding.

- H6 holds the decimal equivalent of the fraction to which you wish to round.

For example, if you wanted to round $ 42.12 to the nearest dime, H10 would have 42.12; H6 would have "0.1". To round to the nearest quarter, H6 becomes ".25".

Obviously, you can adjust the formula to fit.

leonard

2004-09-10 17:15:31

2004-04-11 23:32:59

Comments?

>> Leonard Chan's Homepage
>> Scribble Web
>> Round to Nearest Function Excel

leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.