I have an excel spreadsheet with around 800 people's height/weight. The problem I am having is that the cells height are listed, for example a person who is 5'11" tall the cell value looks like 511. I would want to know a way to adjust these cells into 5'11", so I can obtain their BMI. Any solutions?
I would think you want to convert it to inches. I have a spreadsheet that calculates BMI and there's a formula for meters and the one I use that uses inches.
So if you have 511 in cell A1, this would convert it to 71 for inches.
Formula:
Please Login or Register to view this content.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
That worked...Thank you.
My pleasure. Thanks for the feedback.
Another way: =12*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