Math Functions and Variables in Fusion

Question 1

What function returns the average value of the numeric values in a specific array, or the average value of numerical values entered individually?

Answer 1

average ([array of values]) average(value1; [value2], …)

Question 2

What function returns the smallest integer greater than or equal to a specified number?

Answer 2

ceil (number)

Question 3

What function returns the largest integer less than or equal to a specified number?

Answer 3

floor (number)

Question 4

What function returns a number in the requested format. By default, the decimal point is a comma (,) and the thousands separator is a period (.)?

Answer 4

formatNumber (number; decimalPOINTS; [decimalSeparator]; [thousandsSeparator])

Question 5

What function returns the largest number in a specified array or the largest number among numbers entered individually?

Answer 5

max ([array of values]), max(value1;value2; …)

Question 6

What function returns the smallest number in a specified array or the smallest number among numbers entered individually?

Answer 6

min ([array of values]), min(value1; value2; …)

Question 7

What function parses a string with a number and returns the number?

Answer 7

parseNumber (number; decimal separator)

Question 8

What function rounds a numeric value to the nearest integer.

Answer 8

round (number)

Question 9

What function returns the sum of the values in a specified array or the sum of numbers entered individually?

Answer 9

sum ([array of values]), sum(value1; value2; …)

Question 10

What math variable returns a floating-point pseudo-random number in the range [0,1] (inclusive of 0, but not 1)?

Answer 10

random