|
Q: Elaine Schuman A: 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