How to calculate BMI ratio in Excel BMI is a better index for judging the health of an individual. The syntax for calculating BMI ratio in Excel is as follows: =first cell with the value of weight ...