I am new to this forum and was in dire need of a formula that converts a three digit number in feet and inches to meters. For example 5'9" is written as 509 in cell A1. This needs to be converted to 1.79 meters in B1. Specifically, I need to automatically convert this to meters for body mass index calculation. Even if I can convert this to inches, I can do the rest.
I explored the option of the InchCalc add-in file, but the format has to be displayed as 5' - 9".
Thanks.
Is "509" the required format for entering the data? If I had control over how the data was entered, I would probably enter it as fractional feet 5 9/12. Then use the CONVERT() function http://office.microsoft.com/en-us/ma...551.aspx?CTT=1 to convert fractional feet to meters.
Originally Posted by shg
Assuming 509 is in cell A1
=((VALUE(LEFT(A1,1))*12)+VALUE(RIGHT(A1,2)))*25.4/1000
Elegant Simplicity............. Not Always
Thank you Andy for that wonderful and easy-to-use formula. I had been looking everywhere for the answer for one-and-a-half weeks.
Another way:
=0.3048*DOLLARDE(A1/100, 12)
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks