View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dodo news dodo news is offline
external usenet poster
 
Posts: 2
Default nesting for 2 dependents, and 4 formula options

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