SumSQ()

This function calculates the sum of squares of the numbers provided as arguments to the function. The arguments provided to this function can be numbers, range of numbers, arrays, etc.

Syntax:

= SumSQ (Number1, Number2, Number…)

Number1, Number2, Number: These are numbers for which sum of squares is to be calculated

Example:

• = SumSQ(1, 2, 3) – result will be – 14

This function does calculation as – ((1*1) + (2*2) + (3*3))

RandBetween()

This function returns a random number between a given range of integer numbers

Syntax:

= Randbetween (Bottom_number, Top_number)

Bottom_number: The smallest number that the function will return
Top_number: The largest number that the function will return


Example:

= Randbetween (3,100)

Note: This function is a volatile function, i.e. this function is re-calculated whenever the worksheet gets updated. A heavy use of this function in a workbook can make your workbook calculations slow

Rand()

This function returns an evenly distributed random number between 0 and 1

Syntax:

= Rand ()

Note: This function is a volatile function, i.e. this function is re-calculated whenever the worksheet gets updated. A heavy use of this function in a workbook can make your workbook calculations slow.

In Excel 2007, there is also an advanced version of this function: Randbetween()

SQRT()

This is a simple function which is used to convert find a square root of a number

Syntax:

Sign()

This function is used determine the sign (negative or positive) of a given number. It returns -1 for negative number, 1 for a positive number and, 0 if the number provided is 0

Syntax:

= Sign (Number)

Number: Number for which sign is to be determined


Example: