Ideal Body Weight (IBW) Equations w/ Gender and Height Modifiers

Hi all,
Trying to write one equation that satisfies all of 4 scenarios below and am not having any luck (Column D has (male/female), Column F has (height)):

If Female and Height >/= to 60, IBW = ((Height - 60)*2.3) + 45.5
If Female and Height <60, IBW = 45.5-((60-Height)*0.76))
If Male and Height >/= to 60, IBW = ((Height - 60)*2.3) + 50
If Male and Height <60, IBW = 50-((60-Height)*0.83))

Greatly appreciate any help.

Try

=IF(D2="F",IF(F2>=60,(F2-60)*2.3+45.5,45.5-(60-F2)*0.76),IF(F2>=60,(F2-60)*2.3+50,50-(60-F2)*0.83))

Modified to correct error higlighted

Hello,

how about

=IF(D2="female",IF(F2>=60,((F2-60)*2.3)+45.5,45.5-((60-F2)*0.76)),IF(F2>=60,((F2-60)*2.3)+50,50-((60-F2)*0.83)))

cheers, teylyn

This is my attempt at it, it appears to be correct...
=IF(AND(A2="female",B2>=60),((B2-60)*2.3+45.5),IF(AND(B2="female",B2<60),((45.5-(60-B2)*0.76)),IF(AND(A2="male",B2>=60),((B2-60)*2.3+50),50-(60-B2)*0.83)))
and I'm only guessing at where your values are.