answersLogoWhite

0

A #NAME error occurs when a function name or reference is used in a formula that cannot be found in the spreadsheet. If you were using the SUM function and accidentally type it in as SM then you would get the #NAME error, because Excel would not know what SM is.

A #VALUE error occurs when you try to do a calculation on something that is not numeric. This commonly happens when you a formula to add numbers in cells refers to a cell that has text in it, meaning it can't do the calculation, as you cannot add text and numbers.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is a background formula checking in Excel?

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


What is replicating a formula in Excel?

Replicating means copying. So replicating a formula in Excel is copying a formula. This is a very common activity that is done in Excel. You create one formula and then use it in other places on the worksheet.


The most common error when entering a formula is to reference the wrong cell in the formula?

There are so many kinds of errors in Excel that people make. Many relate to having the wrong cell references and these can cause various kinds of errors. So having the wrong cell reference is really one of the common kinds of mistake.


What do you have to put in a cell to denote an equation in Excel?

In Excel an equation can be a formula. All formulas in Excel must start with the equals sign. That is what tells Excel it is a formula.


How can you describe the Excel application?

Excel is Microsoft's spreadsheet application.


Where is the formula error button in Excel 2007?

There is no formula error button in Excel. However, there is an Error Checking button on the Formulas ribbon in the Formula Auditing section in Excel 2007.


What is the formula for PVIFA in Excel?

The PVIFA formula in excel refers to Present Value Interest Factor of Annuity. This is able to be calculated in an excel document.


How would you describe Auto Complete function in Microsoft Excel?

It allows you to complete a formula by prompting you with possible functions based on the letters you type and giving you help in entering the different components of a function when you have found it. It reduces errors by assisting you to enter your formulas and functions.


What is a rule in excel?

it is a 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


Where Excel displays the formula that is in a cell IS WHAT?

The formula bar.


What is the symbol that tells excel that you are about to begin a formula?

the asterisk is used for what function when building a formula in excel