Dodgy IF Statement

[godders453]

Hi all,

This is my first post, I wonder if anyone could assist? - I'm trying to create a worksheet that calculates a person's Resting Metabolic Rate (RMR), based on criteria of:
1) Gender
2) Age Range
3) Weight in kg
Once the user determines these values, depending on what they answered, the RMR calculator needs to follow one of the following two equation examples:
Male, Aged 10-18: 17.5 * Weight in kg + 651 = RMR
or
Female, Aged 10-18: 12.2 * Weight in kg + 749 = RMR

I have created a statement for the two examples above:
=IF(D31="Male",IF(D33="10-18",C30,IF(D31="Female",IF(D33="10-18",C35,""))))

The first half (Male) calculates fine. However, the second half (Female) returns "FALSE" in my calculation cell. If I remove the Male part of the statement and use only the Female part, it works fine. The two together don't seem to want to play.

My question(s), does anyone see what I'm trying to achieve by adding the Male and Female variables in the same statement, if so, can it be achieved like this. If not, how do I do it?

Hope that all makes sense!

Many thanks

 

[Caleeco]

I think your bracketing is slightly off, try this:

=IF(D31="Male",IF(D33="10-18",C30),IF(D31="Female",IF(D33="10-18",C35,"")))

Is there any need to include the Age Range in the IF statement if they are both the same?

Caleeco

 

[Michael M]

Maybe this

=IF(AND(D31="Male",D33="10-18"),C30,IF(AND(D31="Female",D33="10-18"),C35,""))

 

[godders453]

Maybe this

=IF(AND(D31="Male",D33="10-18"),C30,IF(AND(D31="Female",D33="10-18"),C35,""))

That was fast!! - Cheers Michael, that's got it. Much appreciated!