Best Answer

If there is a problem, Excel will display an error value. The nature of the problem will determine the error value it will show.

User Avatar

Wiki User

โˆ™ 2010-05-13 22:12:39
This answer is:
User Avatar
Study guides

Microsoft Excel

20 cards

How much can you sell a mirraco icon option for

Road wheel torque settings for peugeot 106 1.4

What kind of data do you write on a data table

What tab or dialog box do you use to organize your sources

See all cards
1 Review

Add your answer:

Earn +20 pts
Q: If Excel cannot properly perform a calculation will it display an error value in the cell where you entered the formula?
Write your answer...
Still have questions?
magnify glass
Related questions

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.

Where does Excel display data as its entered?

In both the formula bar and the cell itself.

CTC Salary Calculation Formula?

CTC Salary Calculation Formula?

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?

What does Excel do when a formula is copied into a cell?

If auto-calculation is turned on, it will calculate the formula and display the value. If the formula is composed of relative cell addresses, it will adjust the formula cell references relative to the current location.

What is the formula for calculation fabrics consumption?

What is the formula for calculation fabrics consumption. Which variables have in mind?

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 formula in spread sheets?

It is a code that is entered by the person who wants the spreadsheet to 'do' something. The formula is entered in a cell. Suppose cell A1 contains the number 12 And cell B1 contains the number 8. If the formula in cell C1 is '=A1+B1', then cell C1 will display, not the formula but the answer, i.e. 20.

What is the formula for Cable calculation for 3 phase motors?

The formula for any cable calculation is knowing what the load current is.

A calculation used in excell?

A formula.

What is a mathematical calculation or operation?


Formula for square mass calculation?

What is the formula for mass squared?

What are the contents in Microsoft Excel?

The cell contents are what is actually typed into a cell. This is not always the same as what is displayed. So you can type a formula into a cell, which would be its contents, and the formula will do a calculation and display a result, which is the cell display. When you look at the cell you would see the result of the formula, but not the formula itself. The cell contents are always displayed on the formula bar. If you just type a number in, then the cell content and cell display can be the same. What you could then do is to format the cell and the number would be displayed in that format.

Formula of sdr calculation per usd?

Formula sdr in watershed

What is a calculation used to estimate the answer to a problem before doing an actual calculation called?

A formula.

What is the build in calculation such as sum?

SUM is a function. It can be used as part of a formula which can carry out a calculation.

What is the veloscity calculation formula?


What is the formula for calculation FORCE?

suck my weiner

What is a statement that performs a calculation in a spreadsheet?

A formula.

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.

Where does the answer will display after entering the formula into the cell?

The answer will display in the cell itself.

What is the formula for calculation density?

mass divided by volume

What is the Formula for Volume Calculation of a Solid?

It depends on the solid.

Is there a calculation to figure deadrise?

The degree is based on the design method and the area of operation. there is no fixed formula for its calculation