I apologize for not thanking you earlier for your quick response. As I just
explained to "N Harkawat" the other person who responded to my plea, I am so
impressed by people's willingness to help others. So, I thank you for your
time. Unfortunately, I could not get this to work. I'm sure it is my lack
of experience with compound and complicated functions. I will continue to
study your suggestion and learn what I can from it. Again, I thank you very
much.

"KL" wrote:

You could try something like this:

=IF(AND(B1="in house",C1="Jack"), E1*0.05,IF(AND(B1="in
house",C1="Jill"),E1*0.05,IF(AND(B1="in house",C1=""),E1*0.06,IF(AND(B1<"in
house",C1="Jack"),E1*0.01,IF(AND(B1<"in
house",C1="Jill"),E1*0.01,IF(AND(B1<"in house",C1=""),E1*0.02,""))))))

Regards,
KL

"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.