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