next up previous contents index
Next: WEEKDAY Up: A. Function Reference Previous: VLOOKUP, XLVLOOKUP   Contents   Index


VSUM

Syntax: VSUM(argumentlist)

argumentlist = any combination of numbers, cells or ranges

VSUM returns the ``visual sum'' of its arguments. This function differs from SUM in that it uses the precision and rounding of the actual formatted values appearing in the cells instead of the internal double-precision value of the cell. This ensures that what you see is what you get when calculating a sum.

Examples:

VSUM(L1..L3) = .99 where L1 = 1/3, L2 = 1/3, and L3 = 1/3 and are displayed with two decimal places

Excel function: N/A


next up previous contents index
Next: WEEKDAY Up: A. Function Reference Previous: VLOOKUP, XLVLOOKUP   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003