| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Houw to Round
How do I round up to 614.12 in the formula?
=SUM(I48/1.075) My result is 614.11 I48 is 660.17 and is the total including sales tax. Thanks Tom |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Houw to Round
Hi Tom, Try this, =ROUNDUP(SUM(I48/1.075),2) Regards, Shah Shailesh http://members.lycos.co.uk/shahweb/ (Excel Add-ins) *** Sent via Developersdex http://www.developersdex.com *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Houw to Round
Tom
ROUND(SUM(I48/1.075)+0.005,2) Regards Steve Dalton "Thomas Grassi" wrote in message ... How do I round up to 614.12 in the formula? =SUM(I48/1.075) My result is 614.11 I48 is 660.17 and is the total including sales tax. Thanks Tom |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Houw to Round
On Fri, 1 Apr 2005 22:34:40 -0500, "Thomas Grassi"
wrote in microsoft.public.excel.programming: How do I round up to 614.12 in the formula? =SUM(I48/1.075) My result is 614.11 Correct: 660.17 / 1.075 = 614.111627907 (=614.11) I48 is 660.17 and is the total including sales tax. Ahh, 660.17 is wrong because 614.12 * 1.075 = 660.179 (=660.18) To track down where things go wrong we need more information. -- Michael Bednarek http://mbednarek.com/ "POST NO BILLS" |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Houw to Round
Just another way:
=CEILING(I48/1.075,0.01) Note that your SUM() function is unnecessary: =SUM(I48/1.075) returns the same value as =I48/1.075 In article , "Thomas Grassi" wrote: How do I round up to 614.12 in the formula? =SUM(I48/1.075) My result is 614.11 I48 is 660.17 and is the total including sales tax. Thanks Tom |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Houw to Round
614.11 is the correct answer as shown in response to your first posting.
Jim Thomlinson was apparently mistaken if that is why you are asking the quesion. If you actually want to round up, then you received answers for that. -- Regards, Tom Ogilvy "Thomas Grassi" wrote in message ... How do I round up to 614.12 in the formula? =SUM(I48/1.075) My result is 614.11 I48 is 660.17 and is the total including sales tax. Thanks Tom |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Houw to Round
Thomas Grassi wrote: How do I round up to 614.12 in the formula? =SUM(I48/1.075) My result is 614.11 I48 is 660.17 and is the total including sales tax. Thanks Tom |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Houw to Round
change your frmula to
=roundup(sum(i48/1.075);2) regards, jarot |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round Up and Round Down Time | Excel Worksheet Functions | |||
| Round up or down to $X.X9 or up to $X.X5 | Excel Worksheet Functions | |||
| ROUND UP or DOWN by 0.5 | Excel Discussion (Misc queries) | |||
| round up #.#0 and #.#5 | New Users to Excel | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
Linear Mode
