The multiplication (
*) operator multiplies two numbers together.
a * b
b must be numbers. You can use the VALUE function to convert the arguments to numbers.
b are blank, then the result is also blank. However, if only one is blank, the blank value is treated as zero.
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