answersLogoWhite

0

Sometimes when a number is displayed it may not be an accurate value, due to it being rounded up or down for example. The underlying value is the actual value. It will still be used in calculations, rather than the formatted number that is displayed. So if 3.53 was shown with one decimal place, what you would see is 3.5, but 3.53 is still the underlying value and would be used in any calculations made.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What is underlying formula in Excel?

An underlying formula in Excel is used in a spreadsheet to do something different than the formula does. An underlying formula can be used to remove values or display numbers.


Are there any limitations to the exchange process between Excel and other Microsoft applications?

There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.There would be some. For example if you copy data from Excel into Word, only values will come through, not the underlying formulas.


What actually changes the value Excel stores to a user determined number of decimal places in EXCEL?

In Excel, the displayed number of decimal places is controlled by the cell formatting settings, which can be adjusted through the "Format Cells" menu. Changing the number of decimal places in this menu alters only how the number is displayed, not its actual stored value. Excel retains the full precision of the number internally, irrespective of the formatting applied. Therefore, while users can choose to show fewer decimal places, the underlying value remains unchanged.


What is the value of an alembic Excel 5 string bass?

what is the value of an alembic excel 5 string bass


'How do you do formulas on Excel and continue to work with answer as a numerical value and not a formula '?

'How do you do formulas on excel and continue to work with answer as a numerical value and not a formula '


Excel recognizes an entry as a value if it is a number or it begins with?

Excel recognizes an entry as a value if it is a number or it begins with one of these symbols: +, -, =, @,#, or $ Rina


What is the breakpoint in Excel?

In excel it is the lowest value for a specific category or series in a lookup table.


What symbol is in excel?

There is no symbol for "actual" in Excel, but there is a function to display absolute value (ABS).


What is the y-axis in Excel referred to as?

the y axis in excel is also known as the value axis


What is Actual symbol in Excel?

There is no symbol for "actual" in Excel, but there is a function to display absolute value (ABS).


How do you format an absolute value in Excel?

In excel cell, type =ABS(XXXX). It will return the absolute value of the number or equation you put within the parentheses.


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.