View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
helen helen is offline
external usenet poster
 
Posts: 105
Default Urgent - Having trouble with decimals

Good day,

This is an urgent request... We are adding fees and taxes, but do not want
numbers to round.

Here's what we need:

SUB-TOTAL $2,963.6300

GST $177.8178

QST $235.6086


TOTAL CA $3,377.0564

We would like the total to show $3,377.05 and not $3,377.06.

What formula should we use? By the way, the GST was obtained by multiplying
the first total by 0.05, the QST by multiplying GST and first total by 0.075.

Any help will be greatly appreciated!

Helene