Convert price for Lbs. into Kgs.
Hello, I'm working on a pricing list project and need a formula to convert pounds to kilogram values.
I could use simple math here, but some of the prices are already in kilos, so the formula should take that into account.
Best Answer

Hey @Kashmala Zaman
This formula looks at the unit of measure column for evaluation. If the UoM is already in KGs, it uses the 2021 price. Otherwise, it multiples that price by the conversion factor. ($11.40/
lb* 2.2.046lb/kg). If this isn't the equation you need, you can plug it in  the logic of the IF statement would stay the same.=IF(UoM@row="KG", [2021 Price/...?]@row, [2021 Price/...?]@row*2.2046)
I couldn't read the entire name of the Price column. I had to assume it said something like Price per UoM. Make sure the correct column name is used in your formula.
Verify the conversion factor is exactly the factor you need to use  the number of digits (significant figures) in the factor make a difference.
Let me know if this doesn't work for you and we can tweak it until it does.
cheers
Kelly
Answers

Hey @Kashmala Zaman
This formula looks at the unit of measure column for evaluation. If the UoM is already in KGs, it uses the 2021 price. Otherwise, it multiples that price by the conversion factor. ($11.40/
lb* 2.2.046lb/kg). If this isn't the equation you need, you can plug it in  the logic of the IF statement would stay the same.=IF(UoM@row="KG", [2021 Price/...?]@row, [2021 Price/...?]@row*2.2046)
I couldn't read the entire name of the Price column. I had to assume it said something like Price per UoM. Make sure the correct column name is used in your formula.
Verify the conversion factor is exactly the factor you need to use  the number of digits (significant figures) in the factor make a difference.
Let me know if this doesn't work for you and we can tweak it until it does.
cheers
Kelly

Thanks a lot, @Kelly Moore It works perfectly fine. :)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!