my column totals are exactly 0.01 less

  • Thread starter Thread starter js
  • Start date Start date
J

js

The totals in the columns always calculate with 0.01 less?
is it something in the settings ?
 
Can't be the settings. Are you sure it's not rounding?

Try using =round in your calculations, or set the option Precision as
Displayed.
 
You must log in or register to reply here.

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

% of Pivot Question 4
Table Lookup 4
problem recalculating 1
Calculation 2
Help with normal distribution, generating ratios for bell-shape cu 5
Count 1
complex count formulas using multiple criteria in different ranges 4
Vlookup with 2 Conditions 2

Back
Top