Equivalent to selecting or clearing the Precision As Displayed check box in the Calculation tab of the Options dialog box, which appears when you click the Options command on the Tools menu. Controls how values are stored in cells. Use PRECISION when the results of formulas do not seem to match the values used to calculate the formulas.
Syntax
PRECISION(logical)
Logical is a logical value corresponding to the Precision As Displayed check box in the Calculation tab.
If logical is TRUE, Microsoft Excel stores future entries at full precision (15 digits).
If logical is FALSE or omitted, Microsoft Excel stores values exactly as they are displayed.
Caution The PRECISION function may permanently alter your data. PRECISION(FALSE) causes Microsoft Excel to change values on your worksheet or macro sheet to match displayed values. PRECISION(TRUE) causes Microsoft Excel to store future values at full precision, but it does not restore previously entered numbers to their original values.
Remarks
Precision As Displayed does not affect numbers in General format. Numbers in General format are always calculated to full precision.
Microsoft Excel calculates slightly faster when using full precision because with Precision As Displayed selected, Microsoft Excel has to round off numbers as it calculates.
Related Functions
FORMAT.NUMBER Applies a number format to the selection
WORKSPACE Changes workspace settings
Return to index