How to resolve Excel IF AND question query formula

Need help with a Excel formula. I have two sets of data in two tables, with the same number of columns and rows. One table has data for male, the other one for female. Each table has a common definer (age). All the other data are different. All data are in numbers. Some are negative.

I aim to use a single cell to get a result coefficient used by a specific equation, and I need to channel the input data by two criteria. One is gender, the other one is age. I am trying the IF AND formula, but it is not working.

Here is an example.

age (D2) coefficient (D2-D4) Table Female. 18-30 yrs 25 30-60 yrs 35 60-70 yrs 41 So here is the data to process: D1 F D2 29 D3 115 (MEANING Gender - female; age 29; weight 115 pounds)

I was trying the IF AND formula

=IF(AND(D1="F";D2>17;D2<30);(D3+H2);IF(AND(D2>=30;D2<60);(D3+H4)))

Now, this works fine when I only calculate the female data, but I can't seem the find the way to include the formula to choose from the MALE table, if the subject is male ("M"). Any help or clues on how to resolve this?