Hi,

Try this

=CEILING(A1,0.5)

Where a1 is your calculated dollar amount. Or you can wrap your formula with
the ceiling formula

=CEILING(your formula,0.5)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"DC" wrote:

What function formulation is required to round up calculated dollar amounts
in half dollar increments?