I am having a query, I want to apply a formula based of div and pow^2.

Metric BMI Formula

BMI = weight (kg) / height (mtr)^2

can anyone help me out…

I am having a query, I want to apply a formula based of div and pow^2.

Metric BMI Formula

BMI = weight (kg) / height (mtr)^2

can anyone help me out…

Welcome to the community, @hhfoffice! You could do this as outlined in the image shared below:

Calculate BMI.xlsx (9.1 KB)

1 Like

How to show the BMI categories. Seeking formula…

BMI Weight Status

Below - 18.5 - Underweight

18.5 – 24.9 - Healthy Weight

25.0 – 29.9 - Overweight

30.0 and Above - Obesity

@hhfoffice, you could do it by adding an `if-statement`

as shown in the image below:

Calculate BMI.xlsx (9.2 KB)

1 Like

@hhfoffice, did you try out the exact file I shared? It works perfectly for me. If you have modified the file and used it, please ensure the correct variables that have been used.

if(${C1}<16.0,‘Very Severely Underweight’,if((${C1}>=16.1 and ${C1}<16.9),‘Severely Underweight’,if((${C1}>=17.1 and ${C1}<18.4),‘Underweight’,if((${C1}>=18.5 and ${C1}<24.9),‘Healthy Weight’,if((${C1}>=25.0 and ${C1}<30.0),‘Over Weight’,if(${C1}>30.0,‘Obese’,if((${C1}>=30.0 and ${C1}<34.9),‘Moderately Obese’,if((${C1}>=35.0 and ${C1}<39.9),‘Severely Obese’,if(${C1}>30.0,‘Very Severely Obese’,’’)))))))))

Bit modified in the formula which you have provided me, the above you can see

if(${C1}<16.0,‘Very Severely Underweight’,if((${C1}>=16.1 and ${C1}<16.9),‘Severely Underweight’,if((${C1}>=17.1 and ${C1}<18.4),‘Underweight’,if((${C1}>=18.5 and ${C1}<24.9),‘Healthy Weight’,if((${C1}>=25.0 and ${C1}<30.0),‘Over Weight’,if(${C1}>30.0,‘Obese’,if((${C1}>=30.0 and ${C1}<34.9),‘Moderately Obese’,if((${C1}>=35.0 and ${C1}<39.9),‘Severely Obese’,if(${C1}>40.0,‘Very Severely Obese’,’’)))))))))

This is working till Obese after that it’s reaming Obese only…

@hhfoffice, maybe try this out:

`if(${C1}<16.0,‘Very Severely Underweight’,if((${C1}>=16.1 and ${C1}<16.9),‘Severely Underweight’,if((${C1}>=17.1 and ${C1}<18.4),‘Underweight’,if((${C1}>=18.5 and ${C1}<24.9),‘Healthy Weight’,if((${C1}>=25.0 and ${C1}<30.0),‘Over Weight’,if((${C1}>=30.0 and ${C1}<34.9),‘Moderately Obese’,if((${C1}>=35.0 and ${C1}<39.9),‘Severely Obese’,if(${C1}>40.0,‘Very Severely Obese’,’’))))))))`

But please ensure the range too as I feel the range should be something as shown below (the range you have used for me is like missing or sometimes overlapping):

`<16.0`

OK

`>=16.1 to <16.9`

Maybe it should be `>=16.0 to <=16.9`

`>=17.1 to <18.4`

Maybe it should be `>=17.0 to <=18.4`

`>=18.5 to <24.9`

Maybe it should be `>=18.5 to <=24.9`

`>=25.0 to <30.0`

Maybe it should be `>=25.0 to <=29.9`

`>=30.0 to <34.9`

Maybe it should be `>=30.0 to <=34.9`

`>=35.0 to <39.9`

Maybe it should be `>=35.0 to <=39.9`

`>40.0`

OK

1 Like