- Click cell I3, then type:Profit Margin
- Click cell I4, then type:=
- Click cell G4, then type:/
- Click cell E6, then press the ENTER key.The Profit Margin should be 0.226667:
- Click cell I4.The Formula Bar should read:=G4/E6
- Change the price of the frog to 3.00, then press the ENTER key.
See how the profit margin changes along with the price (cell E4) used in the formula:
- Change the price of the frog back to 2.50.
- In the Title Bar, click the
icon.