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.

**Table of Contents**hide

## Download Practice Workbook

## 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.

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

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

**Excel 365**. 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**

^{2}**calculate price per square meter in Excel**by dividing the

**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.

**Read More: ****How to Calculate Cost per Unit in Excel (With Easy Steps)**

**Similar Readings**

**How to Calculate Price Per Pound in Excel (3 Easy Ways)****Calculate Unit Price in Excel (3 Quick Methods)****How to Calculate Coupon Rate in Excel (3 Ideal Examples)****Calculate Retail Price in Excel (2 Suitable Ways)****How to Calculate Weighted Average Price in Excel (3 Easy Ways)**

### 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.

### 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.

## 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. Please visit our website **Exceldemy** to explore more.

## Related Articles

**How to Calculate Production Cost in Excel (3 Effective Ways)****Calculate Average Price in Excel (7 Useful Methods)****How to Calculate Average Selling Price in Excel (3 Easy Methods)****Calculate Selling Price Per Unit in Excel (3 Easy Ways)****How to Calculate Selling Price in Excel (4 Easy Methods)****Calculate Price Increase Percentage in Excel (3 Easy Ways)****How to Calculate Selling Price from Cost and Margin in Excel**