Urgent - Having trouble with decimals
Yesssss!!! Thank you!
"Gary''s Student" wrote:
If in A1 thru B5:
OUR 2822.5000
ADMINISTRATIVE 141.1300
SUB-TOTAL 2963.6300
GST 177.8178
QST 235.6086
then in B6:
=ROUNDDOWN(SUM(B3:B5),2)
--
Gary''s Student
gsnu200703
"Helen" wrote:
Thank you for responding so fast! Unfortunately, the display I'm getting is
not what I was looking for. Here's my actual data:
OUR FEES $2,822.50
ADMINISTRATIVE CHARGES $141.13
SUB-TOTAL $2,963.6300
GST $177.8178
QST $235.6086
TOTAL $3,377.0564
What am I looking for is to get the total to stay at $3,377.05. If I use
Rounddown, how do I insert it in my formula?
Sorry about insisting...
Helene
"Helen" wrote:
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
|