=IF(B1="in
house",IF(OR(C1="jack",C1="jill"),0.05,ISBLANK(C1) *0.06),IF(OR(C1="jack",C1="jill"),0.01,ISBLANK(C1) *0.02))
will give you either 0.05,0.06,0.01 or 0.02 as output based on the
combinatiion of data on cells B1 and c1



"SR" wrote in message
...
Going nuts trying to make this equation fit all possible situations - I'd
like an equation to put in G that would look at mutliple IFs/ANDs:

IF B="in house" and C=Jack then E x .05
IF B="in house" and C=Jill then E x .05
IF B="in house" and C=(no name) then E x .06
IF B=anything other than "in house" and C=Jack then E x .01
IF B= anything other than "in house" and C=Jill then E x .01
IF B=anything other than "in house" and C=no name then E x .02

Is this possible to do in one equation? All suggestions welcome. Thank
you.