How to Calculate Price Per Square Meter in Excel (3 Handy Methods)

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.

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 m2, 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.

How to Calculate Price Per Square Meter in Excel


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

The following table has Total Area in m2, Total Price, and Price/m2 columns. We will calculate price per square meter in Excel by dividing the Total Price by Total Area in m2.

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/m2 column.

How to Calculate Price Per Square Meter in Excel

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


Similar Readings


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)))

How to Calculate Price Per Square Meter in Excel

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.

How to Calculate Price Per Square Meter in Excel

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

How to Calculate Price Per Square Meter in Excel

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.

How to Calculate Price Per Square Meter in Excel


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

Afia

Afia

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo