0
If Excel cannot properly perform a calculation will it display an error value in the cell where you entered the formula?
Wiki User
∙ 13y ago
That will depend on what the error is. Different problems result in a formula not being able to calculate. The appropriate error message for the situation will be displayed. Here are error messages you will see:
#REF!
#DIV/0!
#NAME?
#NULL!
#N/A!
#NUM!
#VALUE!
Wiki User
∙ 8y ago
Wiki User
∙ 13y agoIf there is a problem, Excel will display an error value. The nature of the problem will determine the error value it will show.
Wiki User
∙ 10y agoIt will usually display an error code, starting with the # sign to indicate what kind of error it is.
Wiki User
∙ 7y agoYes, you will normally get some kind of error, depending on the nature of the problem.
Add your answer:
Earn +20 pts
What happens when the formula is complete and you exit the cell?
The formula will be entered and a calculation will be done and a result displayed.
What is the equation of closing stock?
closing stock calculation formula? closing stock calculation formula? closing stock calculation formula? yes how can i do the closing stock calculation?
CTC Salary Calculation Formula?
CTC Salary Calculation Formula?
Formula for the calculation of gratuity?
Excel Arrears calculation Only Formula Download Excel Arrears calculation Only Formula Download but free download Excel Arrears calculation Only Formula Download but free download not option
What is the formula entered in cell D6?
Any formula can be entered in D6.
What is a cell content on Excel?
It is what is contained within the cell, such as formulas, functions, letters, numbers, symbols, etc. After typing something in, you may see something else, like the result of a calculation by a formula. This is the cell display. So if you type in a formula, it is the cell content, but it will display a result. In reality it is the formula that is in the cell, not what is displayed. So different results will show if values used by the formula change.
What is a mathematical calculation or operation?
Formula
What is a calculation used to estimate the answer to a problem before doing an actual calculation called?
A formula.
Formula of sdr calculation per usd?
Formula sdr in watershed
What is the veloscity calculation formula?
Displacement/time
What is a statement that performs a calculation in a spreadsheet?
A formula.
What are cell display and cell contents in a spreadsheet?
Cell display is what you see when you look at a cell and cell contents are what is in the cell. Sometimes they are the same, like when you type a number into a cell. Sometimes they are different, like when you type in a formula. When you've entered the formula the cell will normally show some value that the formula creates, like a total. So you might see a number, which is the cell display, but the cell still contains a formula, which is the cell content. If you put the cursor onto a cell and look at the formula bar, it will show you what is in the cell. Formatting a cell can also change the cell display, but not the contents. If you put a number into a cell and format it to currency, you will see the currency value, with a currency symbol and probably two decimal places, but the cell still just contains the number you originally entered.
