MULTIPLY (*)

Description

The multiplication (*) operator multiplies two numbers together.

Usage

a * b

Remarks

Both a and b must be numbers. You can use the VALUE function to convert the arguments to numbers.

If both a and b are blank, then the result is also blank. However, if only one is blank, the blank value is treated as zero.

Example

If you have collected the number of households, and want to estimate the number of individuals based on an average household size of 5 people, you could use the formula:

HOUSHOLDS * 5
Next item
NOT (!)