Rounding dollar amounts in half dollar increments

D

DC

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

Mike H

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.
 
J

Joe User

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

It would be helpful if you gave some examples of what you want, because so
many people misuse the words round and round up.

For example, do you want $1.01 to be "go to" $1.00 (round) or $1.50 (round
up)?

Although you could use specialize functions like MROUND(A1,0.50) to round
and CEILING(A1,0.50) to round up, as well as ROUND(A1*2,0)/2, I suggest that
you use on of the following in this case:

=ROUND(A1/0.50,0)*0.05

That gives you the flexibility of change ROUND to ROUNDUP (or even ROUNDDOWN).

In this case, you could also write ROUND(A1*2,0)/2. But then you might not
know what to do if you ever want to round (or round up) to the nickel (
ROUND(A1*20,0)/20 ).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top