Thread: Houw to Round
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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