Better BMI Calculator

<div>0:00 In this video I'm going to show you how to calculate BMI, but I'm also going to show you how to create a BMI calculator, and actually a BMI formula Learn about the syntax used in formulas and functions within your sheets. Opens in new tab that's going to be native to your sheet.<br>0:11 We're going to go into a little bit of Apps Script Discover how to use Apps Script to enhance your Google Sheets functionality. Opens in new tab at the end, but let me show you the formula Learn about the syntax used in formulas and functions within your sheets. Opens in new tab we're going to start to use.<br>0:16 We have a weight in pounds, height in inches, and our formula Learn about the syntax used in formulas and functions within your sheets. Opens in new tab is going to be 703 times, we're going to take the weight, and we're going to divide it by, in parentheses, the height squared.<br>0:32 And there we get our BMI.

I'm going to do a couple of things to this to make sure that we have a nice number Understand how to work with numbers in your sheets, including formatting options. Opens in new tab .<br>0:38 We're going to format Explore various formatting techniques to improve the presentation of your data. Opens in new tab this number Understand how to work with numbers in your sheets, including formatting options. Opens in new tab . We're going to format Explore various formatting techniques to improve the presentation of your data. Opens in new tab it as a number Understand how to work with numbers in your sheets, including formatting options. Opens in new tab , and we can actually get it down to just a single number Understand how to work with numbers in your sheets, including formatting options. Opens in new tab .<br>0:48 We can probably add a couple of decimal points if we want, and there is like a nice BMI number Understand how to work with numbers in your sheets, including formatting options. Opens in new tab . But how do we do this, where Get insights on using the WHERE clause in queries for data filtering. Opens in new tab we want it to essentially be a formula?<br>1:00 Like, we want to be able to go equal BMI, and something comes up. How will we do this?

We'll go up to extensions, Apps Script Discover how to use Apps Script to enhance your Google Sheets functionality. Opens in new tab , and in Apps Script Discover how to use Apps Script to enhance your Google Sheets functionality. Opens in new tab , we can create a formula Learn about the syntax used in formulas and functions within your sheets. Opens in new tab .<br>1:17 We're going to call our function Dive into functions and how to create custom ones for your sheets. Opens in new tab BMI. We're going to take in a weight and a height and And then we're going to return BMI.<br>1:29 Well, we have to actually calculate BMI. We'll get that as well, so we'll go variable BMI equals. We'll take in the weight.<br>1:37 We'll do the exact same formula Learn about the syntax used in formulas and functions within your sheets. Opens in new tab , 7-0-3 times weight divided by height squared. And let's save this and let's see if this works.<br>1:55 Are we going to get the same number Understand how to work with numbers in your sheets, including formatting options. Opens in new tab ?

Equals BMI And we'll select Learn about the SELECT clause in queries to retrieve specific data. Opens in new tab each of these options, it'll load, and we get something else.<br>2:07 Ah, to do the exponential, realize we have to do this, two asterisks. Let's go check our BMI calculation Understand the principles of calculations and formulas in Google Sheets. Opens in new tab . It is perfect.<br>2:16 We can actually replace it here and see that we get the same number Understand how to work with numbers in your sheets, including formatting options. Opens in new tab . Did we get the same number Understand how to work with numbers in your sheets, including formatting options. Opens in new tab ? There we go.<br>2:27 So, how do we make this a function Dive into functions and how to create custom ones for your sheets. Opens in new tab that is native?

We're going to just add a comment Find out how to add comments to your functions for better clarity. Opens in new tab , slash, asterisks, asterisks, and we're going to go custom function Dive into functions and how to create custom ones for your sheets. Opens in new tab , at sign custom function Dive into functions and how to create custom ones for your sheets. Opens in new tab .<br>2:38 We'll save this, and now, let's delete these BMIs, and go equal BMI, and now it is here. We can actually see that we can select Learn about the SELECT clause in queries to retrieve specific data. Opens in new tab this from, ah, as a formula Learn about the syntax used in formulas and functions within your sheets. Opens in new tab .<br>2:51 We can also give it this weight and height is going to show up here, so whatever we write here, weight and height, is going to show up in our function Dive into functions and how to create custom ones for your sheets. Opens in new tab as well.<br>3:00 So now.

BMI is a native function Dive into functions and how to create custom ones for your sheets. Opens in new tab , we just have weight in pounds, and height in inches, and we can get a BMI, as a native function Dive into functions and how to create custom ones for your sheets. Opens in new tab .<br>3:10 Isn't that awesome? This is really cool. If you're a BetterSheets member, and you're watching this on BetterSheets.co, down below, you can get this exact sheet, and this exact Apps Script Discover how to use Apps Script to enhance your Google Sheets functionality. Opens in new tab .<br>3:19 If you're not yet a member, become a member today, over at BetterSheets.co.</div>