Want to calculate price per square meter in Excel? Well, you have come to the right place. Here, we will walk you through 3 easy and handy methods to calculate price per square meter in Excel smoothly.

## What Is Price Per Square Meter?

A space that has one-meter length and one-meter width, is called a square meter. We can calculate price per square meterÂ by dividing the overall price of a property by the summation of square meters in the property.

## How to Calculate Price Per Square Meter in Excel: 3 Methods

The following table has **Total Area in m**** ^{2}**,

**Total Price**columns. We will calculate price per square meter in Excel by using 3 different methods. We will describe these methods step by step in the following article. Here, we used

*Office365*. You can use any available Excel version.

### 1. Dividing Total Cost by Total Area to Calculate Price Per Square Meter

The following table has *Total Area in m ^{2}, Total Price, *and

*Price/m*columns. We will calculate price per square meter in Excel by dividing the

^{2}**Total Price**by

**Total Area in m**

^{2}**.**

**Steps:**

- First, we will type the following formula in cell
**D5**.

`=C5/B5`

This will simply divide cell **C5** by cell **B5**, and the result of division will be **$15**.

- After that,Â press
**ENTER**. Then you will see the result in cell**D5**. - Afterward, we will drag down the formula with the
**Fill Handle**tool.

Finally, we can see calculate price per square meter in the **Price/m**** ^{2}** column.

### 2. Using IF Function to Calculate Price Per Square Meter

Here, we have a criterion list that has 3 criteria.

- Â
**<= 100 Square Meter**cost**$50**. - Â
**101-200 Square Meter**cost**$70**. **>= 200 Square Meter**cost**$90**.

Based on these **3** criteria, we will use **the IF function** to calculate price per square meter in Excel in the **Price/Square Meter **column of the Using **IF** Function table. And after that, we will calculate the total price.

**Steps:**

- First, we will type the following formula in cell
**C5**.

`=IF(B5<=100,50,IF(AND(B5>=101,B5<=200),70,IF(B5>=201,90)))`

**Formula Breakdown**

**IF(B5<=100,50****â†’**returns**50**when**B5**is less than or equal to**100**.**AND(B5>=101,B5<=200)****â†’****The AND function**uses 2 logical conditions. Where one condition is**B5**is greater than or equal to 101, and another condition is**B5**is less than or equal to 200.**IF(AND(B5>=101,B5<=200),70****â†’**returns**70**when one of the conditions is fulfilled.**IF(B5>=201,90)****â†’**returns**90**when**B5**is greater than or equal to 201.**Output: 50**

- After that, press
**ENTER**. Then you will see the result in cell**C5**. - Afterward, we will drag down the formula with the
**Fill Handle**tool.

Finally, we can see calculate price per square meter in Excel in the **Price/Square Meter **column.

Next, we will calculate the total price.

To do so, we will type the following formula in cell **D5**.

`=C5*B5`

This will simply multiply cell **C5 **with cell **B5**.

- After that press
**ENTER**. Then you can see the result in cell**D5**. - Afterward, we will drag down the formula with the
**Fill Handle**tool.

Finally, we can see the complete **Total Price** column.

**Read More:Â **How to Calculate Price Per Pound in Excel

### 3. Calculating Price Per Square Foot

The following table has Property, **Price/Meter Square**, and** Price/Foot Square **columns.

Here, we will convert **Price/Meter Square **to **Price/Foot Square**. We know, that there areÂ **3.2 feet** in **1 meter**. As a result, we get approximately 10.76 (3.2 squared) feet in 1 square meter. Therefore, we will divide Price/Meter Square by 10.76 to get Price/Foot Square.

**Steps:**

- First, we will type the following formula in cell
**D5**.

`=C5/10.76`

This will simply divide cell **C5 **by **10.76**.

- After that, press
**ENTER**. Then you will see the result in cell**D5**. - Then, we will drag down the formula with the
**Fill Handle**tool.

Finally, we can see Calculate pice per square feet in the **Price/Square Foot** column.

## Practice Section

In the practice section of your sheet, you can practice the explained methods.

**Download Practice Workbook**

## Conclusion

Here, we tried to show you how to calculate price per square meter in Excel. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section below.

**<< Go Back to Cost | Formula List | Learn Excel**