Formula

1028
12
Jump to solution
07-18-2022 10:53 AM
DrJumaKhudonazarov
Occasional Contributor II

I need to put a formula on survey 123 to calculate BMI (Body Mass Index). Can someone help me please with how to do that?

12 Replies
DrJumaKhudonazarov
Occasional Contributor II

Sorry for not being clear. I have  3 measurements 

1. <80 cm :

2.  81-102 cm

3.> 103 cm. 

And there 3 risk  groups@

1. Low

2. Medium

3. High

What i want is that if i select   >103 cm   the answer  in next question  should automatically  appear  as  red colour text  High risk,  this may not affect analysis  but the person who measure WC can explain  the risk for that  person . 

0 Kudos
Katie_Clark
MVP Regular Contributor

Ah ok. In this case, I would set up individual "note" type questions that will display conditionally based on the answer selected in the measurement question. You can use HTML formatting in the "Label" column of the XLS form. See example below:

Katherine_Clark_0-1672173272561.png

 

Best,
Katie


“The goal is not simply to ‘work hard, play hard.’ The goal is to make our work and our play indistinguishable.”
- Simon Sinek
DrJumaKhudonazarov
Occasional Contributor II

As always  thank you so much  it works !  

0 Kudos