SOLVED
Home

Problem with Formula

Alison Flynn
Contributor

Hey guys,

I've a wee problem with a formula as follows:

Looking for this result: BMI > 30 or WC > 40 (men), 35 (women)

So if column 'BMI’ >30 and / or column ‘Waist Cir’ >40 if column ‘Gender’ is ‘M’ or >35 if column ‘Gender’ is ‘F’ then the value = 1, otherwise = zero

The formula I'm using is: IF(AND(O3≥40, D3="M"), 1, 0)+IF(AND(O3≥35, D3="F"), 1, 0)+IF(N3≥30, 1, 0).  This is mostly giving the right answer, however, I'm looking for an answer of either 1 or zero.  This formula can give a 2.  Example: BMI 35; WC 42, Gender M = 2.

I think the problem is that there is a '+' before the 3rd part, and think that's causing the addition, however if I put in a comma or AND or OR errors are showing.  

Any ideas how I can correct it please?

Thanks in anticipation!

Gender

BMI

Waist Cir

Obesity RF

F

29

36

1

M

35

42

2

 

 

 

0

 

2 Replies
Solution

Hi,

 

Please try this formula instead:

=IF(AND(O3>40, D3="M"), 1,IF(AND(O3>35, D3="F"), 1,IF(N3>30, 1, 0)))

This syntax is called (Nested IF).

I think that this is what you looking for!

 

Regards

Wonderful, it worked perfectly!  Thanks a million, Much appreciated.

Related Conversations