In this video, you will choose a new number of servings for your recipe.
You will then add a formula to get the conversion factor needed to
adjust your recipe for that number of servings.
So the quantity of each ingredient will update when you increase or decrease the number of servings.
To start, decide how many servings of your recipe you would like to make.
To make the recipe easier to convert, choose a number that is
either half of the original number of servings or a multiple of it.
For example, if the original recipe makes 24 servings,
you could make the new number of servings 12, 48, or 72.
Add a column to your spreadsheet for the new number of servings...
type a heading...
and add the number you chose.
Next, find the conversion factor.
This is the number you will multiply your ingredient quantities by
to make the new number of servings.
Add a column for the conversion factor to your spreadsheet.
To find the conversion factor, use a formula.
All formulas begin with an equal sign.
Formulas in a spreadsheet also use cell references.
A cell reference is like an address that shows the letter of
the column and the number of the row that the cell is located in.
Select the reference for the cell that contains the new number of servings.
And divide that number by the original number of servings.
To divide one number by another, use a slash.