In news:[EMAIL PROTECTED], Pete Holsberg <[EMAIL PROTECTED]> typed: > I would like to round a calculation to the nearest 0.05 (i.e., to the > nearest nickel.
As well as the formulas others have suggested with ROUND, also have a look at FLOOR and CEILING, which allow working with multiples: ceiling(number; multiple; mode). "multiple" (or "significance" or "increment" as the Help calls it) determines what the number will round up to. Eg, with a multiple of 3, then the result will be 3,6,9,12 etc. That is, 2 will round to 3; 2.001 will round to 3; 4.5 will round to 6, etc. You can use decimal multiples, say, 0.05. Then your rounding will result in x.05 or x.10 or x.15 etc. Similiar for FLOOR, which will round down. -- Bob Long --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
