M
mastermk
not sure how to explain, but I am totalling a column that has been multiplied
with another column and it has a 3 digit decimal, I can fix it to show only
the 2 digits, but when I add the column up it is adding ALL of it... for
example
Column A Column B
30.00 (A*13.88%)=B 4.16(4) I can eliminate the (4)
showing.. but it
30.00 4.16(4) still adds it in in
the total at the bottom..
30.00 4.16(4)
total always add the 3rd digit.. I need it to round up/down EACH figure
seperately, so when I add Column B up its should give me a total of 12.48
instead I get 12.49
Thanks
MK
with another column and it has a 3 digit decimal, I can fix it to show only
the 2 digits, but when I add the column up it is adding ALL of it... for
example
Column A Column B
30.00 (A*13.88%)=B 4.16(4) I can eliminate the (4)
showing.. but it
30.00 4.16(4) still adds it in in
the total at the bottom..
30.00 4.16(4)
total always add the 3rd digit.. I need it to round up/down EACH figure
seperately, so when I add Column B up its should give me a total of 12.48
instead I get 12.49
Thanks
MK