 Round values to the nearest fraction |
|
Q: Is it possible to round a dollar amount to the nearest 25 cents? For example, if a number appears as $1.65, I would like to convert it to $1.75. The Round() function in Excel seems to work only with whole numbers. Elaine Schuman A: Yes, you can use Excel's Round() function to achieve the rounding you want. The formula =Round(A1/.25,0)-.25, which assumes that your value is in cell A1, will take care of the job for you. The formula divides the original value by .25 and then multiplies the result by .25. You can, of course, use a similar formula to round values to other fractions. For example, to round a dollar amount to the nearest nickel, simply substitute .05 for each of the two occurrences of '.25' in the preceding formula. If you work with 1-2-3, you can use the @Roundm function to accomplish the same thing, as in @roundm(A1..25). John Walkenbach |
Category:Spreadsheets Issue: May 2000 |
These Web pages are produced by Australian PC World © 2000 IDG Communications