Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding dollar amounts in half dollar increments
What function formulation is required to round up calculated dollar amounts
in half dollar increments? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding dollar amounts in half dollar increments
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding dollar amounts in half dollar increments
"DC" wrote:
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 ). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing Row by Row - A-D dollar amounts to E dollar amount | Excel Worksheet Functions | |||
Total Dollar Amounts From Different Worksheet | Excel Worksheet Functions | |||
column of dollar amounts don | New Users to Excel | |||
Rounding dollar amounts up/down when cents aren't part of the fact | Excel Worksheet Functions | |||
dollar amounts | New Users to Excel |