I want to choose one of four formulas to use, conditional on the contents of
two cells
i.e.
If a1="male" and a2>30, (0.048*a3)+3.653, if a1="male' and a2>60,
(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
Bookmarks