 • 517K Members
• 4,193 Online
• 615K Conversations
SOLVED

Contributor

# Problem with Formula

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

# Re: Problem with Formula

Hi,

`=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

# Re: Problem with Formula

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

Related Conversations