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
Percentage increase
If you have a Form with data that shows the yearly yields of certain products on different Farms, you can use a Calculated Field with a combination of Formulas to calculate the percentage difference between the yearly yields.
To do so, you would use the SUBTRACT (-), DIVIDE (/) and MULTIPLY (*) Formulas along the logic of: (New value minus Old value) divided by the Old value, multiplied by 100).
((yield_2022 - yield_2021) / yield_2021) * 100