Round to Nearest Function Excel

A little formula to round values to the nearest 1/10, 1/4, etc.

=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.
Related Scribbles:
  • Excel Notes
    		•

    ID: 446
    Author:
    leonard
    Date Updated:
    2004-09-10 17:15:31
    Date Created:
    2004-04-11 23:32:59

    Edit
    Comments?
     >> Leonard Chan's Homepage  >> Scribble Web  >> Round to Nearest Function Excel
    leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.