Using Microsoft Excel to calculate multiple numerical values that help in routine business. The “minus” or “subtraction” function in excel is used to calculate the remaining value for instance net profit after subtraction of product price from cost. Following are the easiest steps to use the **subtraction or minus function in Excel**.

## Step 1

**Enter Product name**

Click Cell “B3” and type “Product”. Press the key “Enter”. Click cell “B4” and type the product name such as “Jean” and enter all the product’s names in column B.

**Enter Price**

Click Cell “B3” and type “Price”. Press the key “Enter”. Click cell “C4” and type the price of the individual products in numerical form.

**Enter cost**

Click Cell “D3” and type “Cost”. Press the key “Enter”. Click cell “C4” and type the cost of an individual product in numerical form.

## Step 2

**Subtract cells in Excel**

**Calculate Profit margin by using the Subtraction or minus “-“ function in Excel**

In order to calculate the profit you have earned against individual products sold, you need to calculate the profit by using the **“Subtraction”, “Minus” or “Deduct”** function in Microsoft Excel.

Press **“=”** and select cell “C4” **(Price)** and then enter **“-“** and select “D4” **(Cost)**. Press the key “Enter”.

## Add a Comment