Main page /  Useful info about ShapeSheet™  / Visio ShapeSheet reference / ShapeSheet™. List of functions by category

ShapeSheet. Category Math functions

Note

This table contain only functions which included in table for similar category in the book MS Visio 2003 Developer’s Survival Pack by Graham Wideman (see chapter 37).

The version information in which the function was added is taken from John's Goldsmith article Visio ShapeSheet Functions by Version

Name

Details

ABS

Version Added: Pre 2003

Returns the absolute value of a number.

Syntax

ABS(number)

Read more about function ABS

BOUND

Version Added: 2003

Constrains the value of a cell to a range or set of ranges.

Syntax

BOUND (value, type, ignore, value1, value2 [,ignore(n), value1(n), value2(n),...])

Read more about function BOUND

CEILING

Version Added: Pre 2003

Rounds a number away from 0 (zero) to the next instance of multiple. If multiple is not specified, the number rounds away from 0 to the next integer.

Syntax

CEILING(number, multiple)

Read more about function CEILING

CY

Version Added: Pre 2003

Returns a currency value.

Syntax

CY(value, cyID)

Read more about function CY

FLOOR

Version Added: Pre 2003

Rounds a number toward 0 (zero), to the next integer, or to the next instance of multiple.

Syntax

FLOOR(number, multiple)

Read more about function FLOOR

INT

Version Added: Pre 2003

Rounds a number down to the next integer.

Syntax

INT(number)

Read more about function INT

INTUP

Version Added: Pre 2003

Rounds a number up to the next integer.

Syntax

INTUP(number)

Read more about function INTUP

LN

Version Added: Pre 2003

Returns the natural logarithm of a number. The number must be positive, or LN returns the error value #NUM.

Syntax

LN(number)

Read more about function LN

LOG10

Version Added: Pre 2003

Returns the base 10 logarithm of a number. The number must be positive or LOG10 returns the error value #NUM.

Syntax

LOG10(number)

Read more about function LOG10

MAX

Version Added: Pre 2003

Returns the largest number from a list. Largest means closest to positive infinity.

Syntax

MAX(number1,number2,...,numberN)

Read more about function MAX

MIN

Version Added: Pre 2003

Returns the smallest number from a list. Smallest means closest to negative infinity.

Syntax

MIN(number1,number2,...,numberN)

Read more about function MIN

MODULUS

Version Added: Pre 2003

Returns the remainder (modulus) that results when a number is divided by a divisor.

Syntax

MODULUS(number,divisor)

Read more about function MODULUS

POW

Version Added: Pre 2003

Returns a number raised to the power of an exponent.

Syntax

POW(number,exponent)

Read more about function POW

RAND

Version Added: Pre 2003

Returns a random floating point number from 0.0 to 1.0. It returns a different number each time the function is evaluated, which is once per minute according to the system clock.

Syntax

RAND( )

Read more about function RAND

ROUND

Version Added: Pre 2003

Rounds a number to the precision represented by numberofdigits.

Syntax

ROUND(number,numberofdigits)

Read more about function ROUND

SIGN

Version Added: Pre 2003

Returns a value that represents the sign of a number.

Syntax

SIGN(number,fuzz)

Read more about function SIGN

SQRT

Version Added: Pre 2003

Returns the square root of a number.

Syntax

SQRT(number)

Read more about function SQRT

SUM

Version Added: Pre 2003

Returns the sum of a list of numbers.

Syntax

SUM(number1,number2,...,[numberN])

Read more about function SUM

TRUNC

Version Added: Pre 2003

Returns a number truncated to the specified number of digits.

Syntax

TRUNC(number,numberofdigits)

Read more about function TRUNC