LinkBack URL
About LinkBacks
Is there an add-in or any way to have excel convert other units to grams without creating an equation for each different unit?
Is there an add-in or any way to have excel convert other units to grams without creating an equation for each different unit?
There is a built in function convertIt supports these mass units
CONVERT(number,"unit from", "unit to")You can put the the units and number in separate cells. For example,Weight and mass From_unit or to_unit Gram "g" Slug "sg" Pound mass (avoirdupois) "lbm" U (atomic mass unit) "u" Ounce mass (avoirdupois) "ozm
A1=5
A2 = g
A3 = lbmIs this what you are looking for?=CONVERT(A1,A2,A3) returns 0.011......
A user function could be written with extended capacities I suppose.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Re: Excel Unit Conversion
Good evening cs4
My add-in, available via the link below, has a conversion utility that will convert various units (weight, distance, liquid and temperature) and can convert single amounts to whole ranges and can place the conversions as "hard coded" numbers or formulae, up to 6 decimal places. Once installed, to access it go to Ultimate > Range > Conversion Tools.
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks