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

### Method 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. Calculate price per square meter in Excel by dividing the Total Price by Total Area in m2.

Steps:

• Type the following formula in cell D5.
`=C5/B5`

Divide cell C5 by cell B5, and the result of division will be \$15.

• Press ENTER. Then you will see the result in cell D5.
• Drag down the formula with the Fill Handle tool.

Calculate price per square meter in the Price/m2 column.

### Method 2 – Using IF Function to Calculate Price Per Square Meter

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. Calculate the total price.

Steps:

• 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. 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
• Press ENTER. Then you will see the result in cell C5.
• Drag down the formula with the Fill Handle tool.

Calculate price per square meter in Excel in the Price/Square Meter column.

Calculate the total price.

Type the following formula in cell D5.

`=C5*B5`

Multiply cell C5 with cell B5.

• Press ENTER. Then you can see the result in cell D5.
• Drag down the formula with the Fill Handle tool.

See the complete Total Price column.

### Method 3 – Calculating Price Per Square Foot

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

Convert Price/Meter Square to Price/Foot Square. There areÂ  3.2 feet in 1 meter. Get approximately 10.76 (3.2 squared) feet in 1 square meter. Divide Price/Meter Square by 10.76 to get Price/Foot Square.

Steps:

• Type the following formula in cell D5.
`=C5/10.76`

Divide cell C5 by 10.76.

• Press ENTER. Then you will see the result in cell D5.
• Drag down the formula with the Fill Handle tool.

Calculate pice per square feet in the Price/Square Foot column.

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

Get FREE Advanced Excel Exercises with Solutions!
Afia Kona

Afia Aziz Kona, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Afia exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Apart from creating Excel tutorials, she is also... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF