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?
Bookmarks