Round to Nearest Function Excel

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


- 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
    Date Updated:
    2004-09-10 17:15:31
    Date Created:
    2004-04-11 23:32:59


     >> Leonard Chan's Homepage  >> Scribble Web  >> Round to Nearest Function Excel is hosted by Perceptus Solutions Inc.