Playback Speed:

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.


  1. Insert a column for your new number of servings.
  2. Add the new number of servings.
  3. Insert a column for the conversion factor.
  4. Enter a formula to calculate your conversion factor.