next up previous contents index
Next: WEEKDAY Up: A Function Reference Previous: VLOOKUP

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


next up previous contents index
Next: WEEKDAY Up: A Function Reference Previous: VLOOKUP

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999