IF Statements, Multiple Conditions

[DiamondCutter]

Hello,

I was hoping someone can help me combine all of the variables below into one formula. Here are the conditions that I need:

1) If a="inside" and b=0-6, then c="0"

2) If a="inside" and b=7-12, then c="1.5M"

3) If a="inside" and b>12, then c="2.0M"

4) If a="outside" and b=0-6, then c="0"

5) If a="outside" and b=7-12, then c="1.25M"

6) If a="outside" and b>12, then c="1.5M"

As an FYI, this formula is for a commission payout structure I'm doing for work. Variable "a" indictates whether the representative to receive the commission is an inside sales rep. or an outside sales rep., respectively.

Variable "b" indicates how long the rep. has been with the company.

Variable "c" indicates how much business, in millions, the rep. must do.

Any help would be GREATLY appreciated!!!

[BenjieLop]

Hello,

I was hoping someone can help me combine all of the variables below into one formula. Here are the conditions that I need:

1) If a="inside" and b=0-6, then c="0"

2) If a="inside" and b=7-12, then c="1.5M"

3) If a="inside" and b>12, then c="2.0M"

4) If a="outside" and b=0-6, then c="0"

5) If a="outside" and b=7-12, then c="1.25M"

6) If a="outside" and b>12, then c="1.5M"

As an FYI, this formula is for a commission payout structure I'm doing for work. Variable "a" indictates whether the representative to receive the commission is an inside sales rep. or an outside sales rep., respectively.

Variable "b" indicates how long the rep. has been with the company.

Variable "c" indicates how much business, in millions, the rep. must do.

Any help would be GREATLY appreciated!!!

=if(and(a="inside",b>=7,b<=12),"1.5M",if(and(a="inside",b>12),"2.0M",if(and(a="outside",b>=7,b<=12),"1.25M",if(and(a="outside",b>12),"1.5M",0))))

Hope this helps ...

Regards.

[DiamondCutter]

It worked...thank you very much for your help!!! :o)

[BenjieLop]

You're welcome ... glad to be of help.

Regards.