Formula with two equations

[OverKnight]

I’m trying to write a formula which contains two equations. One equation is used for all females and all males under the age of 15; the other is used just for all males ages 15 and over. The equations are entered in cells B10 and B11 on the attached sheet (DLCO-help.xlsx). The data used in these equations are entered into cells B4 and B5. I have tried separate functions for each equation (in A13 and A14), and these work, but when I combine them (A15) I get a FALSE result. It works for males and females ages < 15, but for males and females > 15, the result is FALSE. Cells A17:A19 are variations I’ve tried. Once I get this working, this formula is to go into cell G5.

I’ll bet it’s pretty simple; I think I burnt myself out for today with the formula in cell E4…

Thank you.

DLCO-help.xlsx

[OverKnight]

I’ll try to rephrase this…
I’m trying to write a formula which contains two equations.
Equation #1: (B6*(10.22+B7)/(1.7*B7)) used for males age 15 and over
Equation #2: (B6*(9.38+B7)/(1.7*B7)) used for all females and for males under age 15

These equations use the data in cells B6 and B7 in their calculations. Cells B4 and B5 are used to determine which equation to use.

I’m having difficulty with the correct syntax. This is what I’ve tried:
IF(B5="Male",IF(B4>=15,(B6*(10.22+B7)/(1.7*B7)),(B6*(9.38+B7)/(1.7*B7)))) returns FALSE with female
IF(B5="Female",IF(B4<15,(B6*(9.38+B7)/(1.7*B7)),(B6*(10.22+B7)/(1.7*B7)))) returns FALSE with male
IF(B5="Male",(B6*(10.22+B7)/(1.7*B7)),IF(B4<15,(B6*(9.38+B7)/(1.7*B7)))) returns FALSE with ages 15 and over

Can anyone assist with this?

Thanks again.

[Jonmo1]

Almost with the first try...

Try IF(AND(Male, >=15),do this, do that)

IF(AND(B5="Male",B4>=15),B6*(10.22+B7)/(1.7*B7),B6*(9.38+B7)/(1.7*B7))

[Jonmo1]

Another way

=B6*(9.38+(0.84*(B5="Male")*(B4>=15))+B7)/(1.7*B7)

[OverKnight]

Thanks very much, Jonmo - I knew it was something simple. I lost most cognitive function around 1:30 PM today...

[Jonmo1]

You're welcome.