answersLogoWhite

0


Best Answer

Normally it won't. What might be happening is if you have decimals in the calculations and some of the values have been rounded. In that instance a calculation may appear to be off, but it is still stored correctly, even if it is not displayed.

Another possibility is if you have a complex calculation and you are making a mistake in how you are doing it or how you are intepreting it. Also remember that Excel follows the laws of mathematics, and if you have any multiplications or divisions in the calculations, they will affect the order the operations are done. See the related question below.

User Avatar

Wiki User

10y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Why does Excel give the wrong answer in subtraction?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Is it true that Excel completes addition and subtraction?

Excel can do any kind of mathematical operation, so that includes addition and subtraction.


Is - a symbol for a mathematical operation in excel?

Yes, it is used for subtraction.


Order followed in excel that starts with negations and ends with subtraction?

oreder of opertaiotn


What are symbols that display mathematical operations such as addition or subtraction in Excel?

The plus sign does adding and the minus sign does subtraction in Excel: =A10+B2 =A2-50 The * is used for multiplication. The / is used for division: =A2*A3 =A6/40


In Microsoft Excel addition and subtraction are considered to be on the same level of?

They are on the same level as each other. Mathematically, addition and subtraction have equal precedence and are done in a left to right order. Microsoft Excel is designed to follow the rules of mathematics, so they have equal precedence.


What are valid format symbols that can be entered with a number in Excel?

Excel does not use format symbols. If this question is asking about arithmetic operators, the symbols are:Addition (+)Subtraction (-)Multiplication (*)Division (/)Exponent (^)


Do the commutative and associative laws apply to vector subtraction?

No, changing order of vectors in subtraction give different resultant so commutative and associative laws do not apply to vector subtraction.


What are some challenges for grade 9?

You give them addition and subtraction


Subtraction is a form of addition and division is a form of multiplication give as example?

nope. Multiplication is a form of addition. Division is a form of subtraction.


What does a green arrow in the corner of an Excel cell mean?

A green arrow in the corner of an excel cell means that excel suspects soemthing may be wrong with the formula in a particular cell.


How do you pass subtraction in xtramath?

Keep giving yourself drills and practicing the ones you get wrong over and over.


What creates a lower level paragraph in Excel?

Excel does not use paragraphs and is the wrong tool for writing letters or any kind of academic writing. I would recommend MS Excel instead.