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.