@gridgurudesignss: Part 4 | How to make a BMI Calculator on Google Sheets! Check out my Fitness Planner Template at bit.ly/GGDPurchase 🫶🏻 BMI FORMULA: =iferror(D15/(D16^2),””) • D15 is the cell containing weight • D16 is the cell containing height VLOOKUP FORMULA: =iferror(vlookup(D17,B22:D26,3,TRUE),””) • D17 is the cell containing the computed bmi • B22:D26 is the range containing the bmi table • 3 is the column number in the bmi table which contains the values you want the formula to return (i.e. underweight, normal, etc) • TRUE returns an approximate match #fyp #trending #SmallBusiness #tutorials #GymTok