Mosteller Body Surface Area (BSA) & Cockcroft-Gault Creatinine Clearance (CrCl)

Two estimation formulas with different purposes and units

Mosteller BSA uses height in centimetres and weight in kilograms: SQRT(height*weight/3600), in square metres. Cockcroft–Gault estimates creatinine clearance in mL/min from age, a chosen weight, serum creatinine in mg/dL and the original equation coefficient. It is not the same as an eGFR reported per 1.73 square metres.

The historical equation uses 0.85 for its female coefficient and 1 for its male coefficient; an unknown entry must not silently select 1. The appropriate equation, weight convention and use of a sex coefficient need clinical judgment. Kidney function estimates can be unreliable with unstable creatinine or unusual body composition. These fictional examples are not for pediatric dosing or direct medication decisions; current drug-specific and clinical guidance must be checked by a qualified professional.

Mosteller Body Surface Area (BSA in m^2)

A2 holds Height in cm (180) and B2 holds Weight in kg (80).

=IF(OR(COUNT(A2:B2)<>2,A2<=0,B2<=0),"Invalid inputs",ROUND(SQRT((A2 * B2) / 3600), 2))

Cockcroft-Gault Creatinine Clearance (CrCl in mL/min)

C2=Age (68), B2=Weight_kg (80), D2=SerumCreatinine_mg_dL (1.25), E2=Sex ("M" or "F").

This exercise accepts adults aged 18 to below 140 and explicit M/F equation coefficients only. Those input bounds are computational checks, not clinical validation. Do not enter creatinine in micromol/L into an mg/dL field.

=IF(OR(COUNT(B2:D2)<>3,B2<=0,C2<18,C2>=140,D2<=0,AND(UPPER(TRIM(E2))<>"M",UPPER(TRIM(E2))<>"F")),"Invalid inputs",ROUND(((140 - C2) * B2 / (72 * D2)) * IF(UPPER(TRIM(E2)) = "F", 0.85, 1), 1))

Further reading

• Microsoft Support — SQRT function
• Mosteller — Simplified calculation of body-surface area
• National Kidney Foundation — Cockcroft–Gault equation and limitations