Function Problems

Enter an Ideal Body Weight Formula in Excel

Nimra MalikNimra Malik Nov 14, 2026 868 views

Question details

The user needs an Excel formula to estimate ideal body weight from height and sex, using height entered in centimeters or inches.

Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet contains a sex indicator and a height value, and should calculate an estimated weight in kilograms.
Observed behavior
The desired result is an estimated ideal body weight calculated from the entered height and sex indicator.
Before you start

Choose whether height will be entered in centimeters or inches. The examples use A1 for M or F and B1 for a numeric height; the result is in kilograms.

Solution 1Recommended

Calculate ideal body weight with an Excel formula

Use an IF formula with the appropriate height unit to estimate weight in kilograms.

The formula uses a base of 50 kg for M or 45.5 kg for F at 60 inches, then adds 2.3 kg for each inch above 60. It is an estimate, not a personalized medical assessment.

1
Enter the inputs

In Excel, enter M or F in cell A1 and a numeric height in cell B1.

2
Enter the formula

Select cell C1. For height in centimeters, enter =(B1/2.54-60)*2.3+IF(A1="M",50,45.5). For height in inches, enter =(B1-60)*2.3+IF(A1="M",50,45.5).

3
Check the result

Press Enter to display the estimate in kilograms. If your inputs are in different cells, edit the A1 and B1 references in the formula.

Check the inputs and interpretation: Any A1 value other than M is treated as F by this formula, so verify the entry. The calculation is commonly used for heights of at least 60 inches; consult a clinician about its use for shorter heights or individual health decisions.
Calculate with WPS Spreadsheets

Calculate ideal body weight in WPS Spreadsheets

Enter the same height and sex inputs in WPS Spreadsheets and use an IF formula to calculate the estimate in kilograms.

  1. 1. Open a spreadsheet: Open WPS Spreadsheets and create a blank workbook or open an existing Excel file.
  2. 2. Enter the inputs: Type M or F in A1 and a numeric height in B1.
  3. 3. Add the formula: Select C1 and enter =(B1/2.54-60)*2.3+IF(A1="M",50,45.5) for centimeters, or =(B1-60)*2.3+IF(A1="M",50,45.5) for inches.
  4. 4. Calculate and save: Press Enter to see the estimate in kilograms, then use File > Save As to save the workbook in XLSX format.
Calculate estimated body weight from height in centimeters or inchesOpen and save Microsoft Excel XLSX filesUse familiar spreadsheet formulas and cell referencesEdit spreadsheets with a free, easy-to-use office suite
microsoft office alternative - wps office

Frequently Asked Questions

How do I calculate ideal body weight when height is in inches?

With M or F in A1 and height in inches in B1, enter =(B1-60)*2.3+IF(A1="M",50,45.5) in a result cell. The result is in kilograms.

Why does the centimeter formula divide height by 2.54?

Dividing B1 by 2.54 converts centimeters to inches before the formula compares the height with 60 inches.

What happens if A1 does not contain M or F?

The IF formula treats any value other than M as F. Check A1 and enter M or F before relying on the result.

Can I use different cells for the inputs?

Yes. Edit the formula in the result cell and replace A1 with your sex-indicator cell and B1 with your height cell.