Houw to Round

[Thomas Grassi]

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

[Steve Dalton]

Tom

ROUND(SUM(I48/1.075)+0.005,2)

Regards

Steve Dalton

"Thomas Grassi" <[email protected]> wrote in message
news:%[email protected]...
> 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
>
>

[Shailesh Shah]

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 ***

[Michael Bednarek]

On Fri, 1 Apr 2005 22:34:40 -0500, "Thomas Grassi"
<[email protected]> 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"

[JE McGimpsey]

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 <#[email protected]>,
"Thomas Grassi" <[email protected]> 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

[Tom Ogilvy]

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" <[email protected]> wrote in message
news:%[email protected]...
> 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
>
>

[[email protected]]

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

[[email protected]]

change your frmula to
=roundup(sum(i48/1.075);2)

regards,

jarot