How to Calculate Price Per Pound in Excel (3 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

Excel is the most widely used tool when it comes to dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes, we need to calculate price per pound for our daily activities. In this article, I will show how to calculate price per pound in Excel. I am going to demonstrate 3 easy ways here.


How to Calculate Price Per Pound in Excel: 3 Easy Ways

This is the dataset that I am going to use. I have the amounts of some products and their price. I will calculate price per pound (lb) now.

how to calculate price per pound in excel


1. Divide Amount by Price to Calculate Price Per Pound

This is a very simple method. Let’s execute it step by step.

Steps:

  • Go to E5. Write down the following formula
=C5/D5

  • Press ENTER. You will get the price per pound.

how to calculate price per pound in excel


2. Convert Amount in Kg to Pound

Sometimes the amounts are in kg. In these cases, we have to convert the amount from kg to lb. The relationship between kg and lb is 1 kg = 2.2 lb.

Steps:

  • Go to E5. Write down the following formula
=D5*2.2

how to calculate price per pound in excel

  • Press ENTER to convert from kg to lb.

  • Use Fill Handle to AutoFill up to E9.

how to calculate price per pound in excel

Now let’s calculate the price per pound using the amounts in lb. To do so,

  • Go to F5 and write down the formula.
=C5/E5

  • Press ENTER. You will get the price per pound.

how to calculate price per pound in excel

  • Then use Fill Handle to AutoFill up to F9.


3. Use CONVERT Function to Calculate Price Per Pound

We can also use the CONVERT function to convert the amount from kg to pound. Then we can calculate the price per amount.

Steps:

  • Go to E5 and write down the following formula
=CONVERT(D5,"kg","lbm")

how to calculate price per pound in excel

While writing this formula, Excel will show a list of units. You can either choose from these or write manually.

  • Now press ENTER. Excel will convert the amounts.

how to calculate price per pound in excel

  • Then, use Fill Handle to AutoFill up to E9.

After that, we will calculate the price per pound. To do so,

  • Go to F5. Write down the following formula
=C5/E5

how to calculate price per pound in excel

  • After that, press ENTER to get the result.

  • Use Fill Handle to AutoFill up to F9.

how to calculate price per pound in excel


Things to Remember

  • The relationship between kilogram and pound is 1 kg = 2.2 lb.
  • If the required unit is not in the list of CONVERT function arguments, you can write it manually.

Download Practice Workbook

Download the workbook and practice while going through this article.


Conclusion

In this article, I have demonstrated 3 effective methods on how to calculate price per pound in Excel. I hope it helps everyone. And lastly, if you have any kind of suggestions, ideas, or feedback please feel free to comment down below.


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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Akib Bin Rashid
Akib Bin Rashid

AKIB BIN RASHID, a materials and metallurgical engineer, is passionate about delving into Excel and VBA programming. To him, programming is a valuable time-saving tool for managing data, files, and internet-related tasks. Proficient in MS Office, AutoCAD, Excel, and VBA, he goes beyond the fundamentals. Holding a B.Sc in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, MD AKIB has transitioned into a content development role. Specializing in creating technical content centred around Excel and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo