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

 

[Shailesh Shah]

Hi Tom,
Try this,

=ROUNDUP(SUM(I48/1.075),2)

Regards,
Shah Shailesh
http://members.lycos.co.uk/shahweb/
(Excel Add-ins)

 

[Steve Dalton]

Tom

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

Regards

Steve Dalton

 

[Michael Bednarek]

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.

 

[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

 

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

 

[jarot911]

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

 

[jarot911]

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

regards,

jarot