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