Hi gang,
This is a puzzle for me. I want a formula to determine if a user's body fat content is lean, ideal, average or bad based on these ranges per age per gender:
bodyfatchart.jpg
I already have the table on excel, but not sure how to upload it. It's been a while since I've used the site guys. Sorry.
Example.png
From the above you can see that I basically re-arranged in ranges the information from the first chart above. So I'd like the results in C27 and C33.
EDIT: Sorry guys, the classification for the second example should be "Above Average" in Red.
Ron
Bookmarks