How force total of calculated numbers to that of displayed digits.

G

Guest

On an invoice, tax and other percentages are used to calculate line total
which are displayed with 2 decimals. The column total includes all digits in
the calculations, therefore does not always agree with the sum of the
displayed numbers.
The value .034 is displayed as .03, however if two lines are .034, each will
display as .03 for a total of .06. However, the total will be display as
..07.
 
C

Chip Pearson

John,

Go to the Tools menu, choose Options, then the Calculation tab.
There, check the "Precision as displayed" setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problem with adding columns of numbers 1
Find the combination of numbers that when added equal a reqired total?? 5
Sum using displayed values not calculated values 2
How to calculate total hours 1
How do I sum rounded values from two seperate formulas in Excel? 1
showing total of 10 digits. 4
Adding up Percentage calculated series of numbers???? 1
Subtotal of Subtotal displays Grand Total in wrong row 5

Top