Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • When Excel functions are not enough Excel User tips
  • Validation based on another Validation COUNTA
  • Multiple Dual-Validations COUNTA
  • Count Unique COUNTIF
  • OFFSET+MATCH Formulas - combined functions
  • Formula Beautifier Excel User tips
  • Get monthly total from table with dates DATE
  • Sort list dynamically (functions) COLUMN

BMI Calculator

Posted on December 5, 2018 By ANmar

A simple calculator, how come we do not have one like this?

You can enter your weight in kilograms (kg) or pounds (lb), then your height in centimeters (cm) or inches (inch), the calculator will do the rest

You may also see the calculation in large blue cell showing BMI (also in “Calculated” fields) if you want

 

Download BMI Calculator
Excel Online
Basic Math, IF Tags:BMI, Calculator, Convert

Post navigation

Previous Post: Skills Grid
Next Post: Edit directly in cell

Related Posts

  • Cells with additional spaces AND
  • CHOOSE – tree of decisions CHOOSE
  • Sum of divide – Array formula Array formula
  • Limited Ceiling Basic Math
  • SimpleANBox Basic Math
  • Middle name + 1st name Basic Math

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (82)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (5)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Workdays – Across months DATE
  • Multiple-Validations (connected to each other) Data Validation
  • Progress bar in pure functions CHAR
  • Worksheet name, dynamically using formula CELL
  • Sum of divide – Array formula Array formula
  • VALUE() of LEFT() Formulas - combined functions
  • CHOOSE – tree of decisions CHOOSE
  • Comments versus Notes Excel User tips

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme