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
|