Enter an Ideal Body Weight Formula in Excel
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.
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.
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.
In Excel, enter M or F in cell A1 and a numeric height in cell B1.
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).
Press Enter to display the estimate in kilograms. If your inputs are in different cells, edit the A1 and B1 references in the formula.
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. Open a spreadsheet: Open WPS Spreadsheets and create a blank workbook or open an existing Excel file.
- 2. Enter the inputs: Type M or F in A1 and a numeric height in B1.
- 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. Calculate and save: Press Enter to see the estimate in kilograms, then use File > Save As to save the workbook in XLSX format.

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.




