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