Akib Bin Rashid
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.
Download Practice Workbook
Download the workbook and practice while going through this article.
3 Easy Ways to Calculate Price Per Pound in Excel
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.
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.
- Use Fill Handle to AutoFill up to E9.
Read More: How to Calculate Price Per Square Meter in Excel (3 Handy Methods)
Similar Readings
- How to Calculate Selling Price from Cost and Margin in Excel
- Calculate Cost per Unit in Excel (With Easy Steps)
- 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. 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
- Press ENTER to convert from kg to lb.
- Use Fill Handle to AutoFill up to E9.
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 price per pound.
- Then use Fill Handle to AutoFill up to F9.
Read More: How to Calculate Unit Price in Excel (3 Quick Methods)
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")
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.
- Then, use Fill Handle to AutoFill up to E9.
After that, we will calculate price per pound. To do so,
- Go to F5. Write down the following formula
=C5/E5
- After that, press ENTER to get the result.
- Use Fill Handle to AutoFill up to F9.
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.
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.
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 Bond Price in Excel (4 Simple Ways)
- How to Calculate Projected Cost in Excel (4 Effective Ways)
- Calculate Discount Price in Excel (4 Quick Methods)
- How to Calculate Price Increase Percentage in Excel (3 Easy Ways)
