VSUM(<List>)

 

Description

This function returns the "visual sum" of its arguments.  This function differs from SUM in that it uses the precision and rounding of the formatted values appearing in the cells instead of the internal double-precision values of the cells.

 

VSUM recalculates when the cell values of the referenced cells change.  If you change the format of the referenced cells but not the values, you must manually update the cell with the VSUM formula; for example, you can edit the cell and add a space character at the end.

 

Parameters

 

<List>

Any combination of numbers, cells or ranges.

 

Examples

 

VSUM(L1:L3) = .99

Where L1 = 1/3, L2 = 1/3, and L3 = 1/3, displayed to two decimal places.