On Nov 15, 4:43 pm, JE McGimpsey wrote:
Assuming your values are integers, one way:
=CEILING(A1 - 2.0000000001, 5)

Given your assumption, why not simply:

=ceiling(A1 - 2, 5)

In both cases (yours and mine), this assumes A1 = 2.

But I would write CEILING(INT(A1)-2,5) to avoid the assumption.


----- original posting -----

On Nov 15, 4:43*pm, 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)