Excel vs. calculator multiplication product discrepancy...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm experiencing a slight rounding error in comparing the Excel product of
simple multiplication equations versus the product achieved using a
calculator! Anyone know for certain how to adjust Excel to mirror the
calculator?
 
Details, please.
What formulas, what values, what did your calculator give, what did Excel
give you and what do you consider right and why?

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 
what is the number of significant figures in the calulator?
addtionally for some fuctions, probably different algorithms were used in
the calculator than Excel.
 
I've discovered my user error, reducing decimal places mid-equation... thank
you for you earnest efforts and assistance interest.
-John
 
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

How does Excel calculate Multiple R when doing multiple regression 1
need help for a beginer! 3
how do i set up product pricing calculator? 1
Quicker calculations -- storing huge equations or cutting and past 2
Need help in rounding answers to nearest multiple 6
Number of total calculation functions 3
Calculating multiples of a number 5
Excel Functions 2

Back
Top