Multiple Nested IF(AND's in a formula

[jwmartin32]

Hi Everyone,
I am new to Excel formulas and am trying to figure out a foruma to calculate Body Fat Percentage. I have two columns, AGE and BF%. I need a formula that does the following:

IF Age >18, <39 AND BMI >7%, <19%, Then return an "L" into 4th column
IF Age >18, <39 AND BMI >19%, Then return an "H" into 4th column
IF Age >40, <59 AND BMI >14%, <23%, Then return an "L" into 4th column
IF Age >40, <59 AND BMI >23%, Then return an "H" into 4th column
IF Age >60 AND BMI >15%, <24%, Then return an "L" into 4th column
IF Age >60 AND BMI >24%, Then return an "H" into 4th column

So far I have:
=IF(AND(B2>=18,B2<=39,C2>=14,C2<=23),"L","H")*OR(IF(AND(B2>=40,B2<=59,C2>=18,C2>=30),"L","H")*OR(IF(AND(B2>=60,C2>=21,C2>=31),"L","H")))
but all that returns is a #VALUE in the cell. Could anyone please help with this formula?
Thanks!
jwm

[EdMac]

Something like

=IF(AND(B2>60,C2>24%),"H",IF(AND(B2>60,C2>15%,C2<24%),"L",IF(AND(B2>40,C2>23%),"H",IF(AND(B2>40,B2<59,C2>14%,C2<23%),"L",IF(AND(B2>18,B2<39,C2>19%),"H",IF(AND(B2>18,C2>7%,B2<19%),"L","What"))))))

This could be simplified further by using OR combinations where the result is going to be the same to reduce the number of IF statements.

As a general rule start with the last condition and work backworks

[daddylonglegs]

Try this formula

=IF(AND(B2>=18,B2<=39), IF(C2>0.19,"H", IF(C2>0.07,"L","")), IF(AND(B2>=40,B2<=59), IF(C2>0.23,"H", IF(C2>0.14,"L","")), IF(B2>=60, IF(C2>0.24,"H", IF(C2>0.15,"L","")),"")))