nesting for 2 dependents, and 4 formula options
=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
|