The display value of the cell is used. If the cell's actual value is 10.005, but it is using currency formatting, it will display as $10.01. When this cell is used in calculations, its displayed value of 10.01 will be used.
The actual value of the cell is used. If the cell's actual value is 10.005, but it is using currency formatting, it will display as $10.01. When this cell is used in calculations, its stored value of 10.005 will be used, even though the display shows a slightly different value.
Represents the types of precision which can be used when obtaining the value of a cell.