answersLogoWhite

0

Why does Excel make rounding errors?

Updated: 8/19/2019
User Avatar

Wiki User

12y ago

Best Answer

All computers make rounding errors because they have only a finite amount of memory in which they can store numbers.

While it is possible to increase the amount of memory allocated for storing each number, doing so would slow down the processing.

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Why does Excel make rounding errors?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What instructs excel to display a value as a percentage by multiplying by 100 and rounding?

percent style button


What can a decrease decimal tool do in excel?

It reduces the number of digits after the decimal point in the display, rounding the number as appropriate.


What is instruts excel to display a value as a percentage by multiplying by 100 and rounding?

use format, under numbers select percentage


What is a background formula checking in Excel?

Excel continually reviews the workbook for errors in formulas as you create or manipulate it


What debugging in Excel?

Debugging means find errors and fixing them so that a computer program works properly. In Excel, that would be applied to finding errors in your spreadsheet formulas and fixing them.


Rounding off to the first digit is called?

Rounding to the first digit is simply called rounding. This will make the number equal to the same as what the number truly is.


What does Excel use to check for spelling errors?

Spell checker


Does Excel make beef?

Excel produces and sells beef


How do you make a result sheet in Excel?

how to create a excel sheet


When finding the percentage of a number Excel answer is different than my calculator?

First, you need to make sure you are doing the calculation correctly. You need to make sure you are using the same approach. Then there is the possibility that they are rounding up the results in different ways and so the result appears to be different, but actually isn't.


How do you make a graph without Excel?

You can only make it by hand if you don't want to use excel


Why sometimes is recurring notation better than rounding off?

Rounding off will result is a small error. If there are many subsequent calculations using a rounded off number, these errors could accumulate.