How to calculate profit and loss and selling price for Potion (3) and (4)

Screen shot of the Excel file.

                                      [Link]

If you don't want to download the file and would like to make your own one. Simply make layout like the above images. 

To calculate total cost type: =SUM(D9:D11)

Note: D9: D11 should be your cell number.  see the images below.

 

So now when u enter the cost of the product the total cost will automatically get calculated. Now to selling price for the  Potion 3 is the the total cost.

If you like that figure to appear on different box like mine  simply enter =cell number.  see the image below.

Now to Find sell price of Potion 4. Simply type  =(D13/3)*4

Note the G13 is the total price so type in the cell number that has the total cost. so in the above example it would be D13.