Thanks for prompt reply Bob and Tom,

i've messed with your syntax and am still having error reports
have broken up the formula into lines to make it easier to read.
Would greatly appreciate your perusal.
TIA

=IF(AND(B3="male",B460),(0.049*B6)+2.459)/0.004184,
IF(AND(B3="male",B430),(0.048*B6)+3.653)/0.004184,
IF(AND(B3="female",B460),(0.038*B6)+2.755/0.004184,
IF(AND(B3="female",B430),(0.048*B6)+3.653)/0.004184,"out of range")








=If (And(a1="male",a230), (0.048*a3)+3.653, if(And(
a1="male",a260),(0.049*a3)+2.459,"burp"))

should work for 5 more, 7 is the limit


=IF(AND(A1=1,B1=1),1,IF(AND(A1=2,B1=2),2,IF(AND(A1 =3,B1=3),3,IF(AND(A1=4,B1=
4),4,IF(AND(A1=5,B1=5),5,IF(AND(A1=6,B1=6),6,IF(AN D(A1=7,B1=7),7,8)))))))

--
Regards,
Tom Ogilvy



"dodo news" wrote in message
...
I want to choose one of four formulas to use, conditional on the contents
of
two cells

i.e.
If a1="male" and a230, (0.048*a3)+3.653, if a1="male' and a260,
(0.049*a3)+2.459, if for two more formulas

I was trying to do a combined =IF(AND, but this doesn't seem to be
nestable....

Any help appreciated....
TIA