Forum Discussion
calculate value based on displayed value
I have the following formula in cell C18 =C16*C19/10 Cell C16 contains the value 2.37 and Cell C19 contains the value 80. Cell C18 displays the value as 19.0, but the actual value is 18.9...
This is a feature in Excel.
- From the top menu select File
- From the bottom left select option, this opens the Excel Options window
- From the left select advanced
- Scroll down almost to the bottom, Look for the "Set Precision as Displayed" check box.
Excel will now use the displayed number when calculation. Example in A1 cell put =10/3 and set the display to show two digits after the decimal place it will show 3.33. Now in cell B1 put =A1*3 the anser will be 9.99.
