Rounding numbers up or down in same formula
You might consider this formula (it appears to work with both positive and
negative numbers)...
=5 * INT((A1 + 2.5) / 5)
--
Rick (MVP - Excel)
"Tired" wrote in message
...
I was hoping to figure out how to set up parameters to either round up or
round down in the same formula depending on the data.
However, individually implementing CEILING and FLOOR has worked as an
interim measure.
Thanks.
"JE McGimpsey" wrote:
Assuming your values are integers, one way:
=CEILING(A1 - 2.0000000001, 5)
In article ,
Tired wrote:
A value ending in 0 through 2 needs to round down to 0 (e.g., $25,402 =
$25,400).
A value ending in 3 through 5, needs to round up to the nearest 5
(e.g.,
$24,174 = $24,175).
A value ending in 6 through 7, needs to round down to the nearest 5
(e.g.,
$18,217 - $18,215).
A value ending in 8 or 9, needs to round up the nearest 10 (e.g.,
$14,408 =
$14410)
|