Please ensure Javascript is enabled for purposes of website accessibility
September 24, 2023

Use Excel to Keep an Eye on Your BMI This Busy Season

Let’s assume that you’ve bought into the quantified-self craze. Your wearable technology measures every breath you take and every move you make, so now it's time for new frontiers, as in something other than the fast food drive-thru lane. It’s always easiest to start with low-hanging fruit, such as your co-workers. Body Mass Index is a snap to calculate with Excel. You’re just two simple measurements and a worksheet function away. You’ll make Professor Don Tillman proud.
The first measurement you need is your height. If you've been slacking on your annual doctor's visit, either have a co-worker make you STAND UP STRAIGHT next to a wall or invite them to a Slurpee break and use the handy ruler on the convenience store’s doorframe. The second measurement you'll need is your weight. If you've been avoiding the scale for a while, no problem, you’re an accountant— make an estimate! The 10 pounds you put on every busy season is immaterial. For the purposes of this post, let’s use the average United States male height and weight of 195 pounds and 70 inches, respectively.
With these stats in hand you’re ready to fire up a blank Excel worksheet. As shown in Figure 1:
• Put the word Weight in cell A1, and then enter your pounds into cell B1.
• You can probably anticipate that height will go in the next row down. Use inches, just like the convenience store door does.
Now let’s pause for a bit of backstory. That treasure trove of medical knowledge known as the Internet shows a myriad of ways to calculate BMI. Most use rough approximations, but Excel will let us calculate BMIs out to fifteen decimal places. A commonly used BMI calculation involves converting one’s weight into kilograms, and height into meters. You then square the height and divide the result into the weight. It’s actually much easier than it sounds: 
• Enter BMI into cell A3 and then this formula in cell B3:

Figure 1: Use the CONVERT function to calculate BMI on the fly.
• Round off the decimals in cell B3 and you’ll see the average US male has a BMI of 27.98. Drop in the average US female’s weight/height of 165 pounds and 64 inches in cells B1 and B2 to return a BMI of 28.32. 
Regardless, the CONVERT function is available in all versions of Excel and allows you to transform various measurements from one to another. You can probably surmise what abbreviations within the CONVERT function mean but I’ll spell them out just in case:
lbm – Pound Mass (as opposed to lbf for Pound Force)
kg – Kilograms (oddly this abbreviation won’t appear in the dropdown lists as you type the formula but it is a valid abbreviation)
in – Inches
m – Meters
The last two characters of the formula, “^2” square the result of the second CONVERT function. An Excel rookie would have taken this approach instead:
So there you have it, a new Excel function in your toolbox and some bits of meaningless information about the American public.
And here's a little bonus: you can put the formula to good use by converting the number of pints of beer you drink in a week to gallons. Enter your alcohol intake in cell A1 of a worksheet, and this formula in any other cell:
Whichever guilty pleasure — snacks or beer — you reach for a little too often this busy season, you can see how well (or not) you're handling it. 
About the author:
David H. Ringstrom, CPA, heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at [email protected] or follow him on Twitter.

Latest Accounting Jobs--Apply Now:

Have something to add to this story? Give us a shout by email, Twitter, or text/call the tipline at 202-505-8885. As always, all tips are anonymous.

Comments are closed.

Related articles

Upset stressed woman holding cellphone disgusted shocked with message she received isolated grey background. Funny looking human face expression emotion feeling reaction life perception body language

6 Ways Email is Secretly Destroying Your Accounting Firm

Email: The word itself sounds innocent, doesn’t it? Kind of like “snail mail,” but faster, sleeker, and without the slimy trail. But don’t be fooled—email is secretly a sinister beast, hiding in the shadows as it plots to destroy businesses—including your accounting firm. If your accounting firm still relies heavily on email for client communication […]

an empty office to represent talent shortage

Research: The Talent Shortage is Starting to Take Its Pound of Flesh From Corporate Tax Departments

This morning, Thomson Reuters released new research that reveals both corporate tax and global trade departments state they are under-resourced for technology and talent. This, naturally, is increasing risk in the form of penalties and audits. The latest research piggybacks a bit on what was revealed in their Future of Professions report released last month. […]