Your calculations call for you to either round or truncate values in your spreadsheet.
Use one or more of the builtin functions shown in Table 76.
Table 76. Excel functions for rounding and truncating
Function 
Syntax 
Description 



Rounds the number 


Rounds the number 


Rounds the number 


Rounds the number 


Rounds the number 


Rounds the number 


Rounds the number 


Rounds the number 


Truncates the number 
In Excel you can format any cell displaying a value to display that value to a specified number of decimal places. For example, you can format a cell containing the value 4.5837450 to display the number to only two decimal places (that is, 4.58). Formatting a cell to display only a certain number of decimal places does not change the underlying value; it only changes what's shown in the cell. To actually change the value, you need to use the rounding ...
No credit card required