Dynamic Components Function Examples

Dynamic Components Function Examples

Math Functions

Function Description Example(s)
ABS(number) The ABS function returns the absolute value of number. View SketchUp Example
CEILING(number, significance) The CEILING function rounds number to the nearest integer or multiple of significance. The significance argument is the value to whose multiple of ten the value is to be rounded up (.01, .1, 1, 10, etc.). View SketchUp Example
DEGREES(number) The DEGREES function converts the number (in radians) to degrees. View SketchUp Example
EVEN(number) The EVEN function rounds the number up to the nearest even integer. View SketchUp Example
EXP(number) The EXP function returns e raised to the power of number. View SketchUp Example
FLOOR(number, significance) The FLOOR function rounds the number down to the nearest multiple of significance. The significanceargument is the value to whose multiple of ten the number is to be rounded down (.01, .1, 1, 10, etc.). View SketchUp Example
INT(number) The INT function rounds the number down to the nearest integer. View SketchUp Example
ISEVEN(number) The ISEVEN function returns TRUE if the number is an even integer, or FALSE if the number is odd. If the number is not an integer, the function evaluates only the integer part of the number. View SketchUp Example
ISODD(number) The ISODD function returns TRUE if the number is an odd integer, or FALSE if the number is even. If value is not an number, the function evaluates only the integer part of the number. View SketchUp Example
LN(number) The LN function returns the natural logarithm based on the constant e of the number. --
LOG10(number) The LOG10 function returns the base-10 logarithm of the number. View SketchUp Example
ODD(number) The ODD function rounds the number up to the nearest odd integer. View SketchUp Example
PI() The PI function returns the value of PI to fourteen decimal places. --
RADIANS(number) The RADIANS function converts the number (in degrees) to radians. View SketchUp Example
RAND() The RAND function returns a random number between 0 and 1. View SketchUp Example
RANDBETWEEN(bottom, top) The RANDBETWEEN function returns a whole number between the bottom and top number. Example:
   =RANDBETWEEN(1,3)
Returns a 1, 2, 3.

View SketchUp Example
ROUND(number, count) The ROUND function rounds the number to a certain number of decimal places according to valid mathematical criteria. The count argument is optional and represents the number of the places to round the number. If the count argument is negative, only the whole number portion is rounded. Example:
  =ROUND(1.12789,2)
Returns 1.13.

View SketchUp Example
SIGN(number) The SIGN function returns the sign of the number. The function returns the result 1 for a positive sign, -1 for a negative sign, and 0 for zero. View SketchUp Example
SQRT(number) The SQRT function returns the positive square root of the number. The value of the number must be positive. --