# multiple conditional IF AND

#### jumboh

##### New Member

This is a commission project... need the formula to go in B3.

A1 will have values... (90, 93) this is save percentage
B1 will have values... (10, 12) current rate for an account
B2 will have values... (12, 14) what the rep upgrades the account to.
B3 = ??? (commission)

If a rep save % is at 90 and upgrades a \$10 account to a \$12 he gets \$5, to a \$14, he gets \$7 etc. But if save percentage is at 93% he gets \$6 to go from 10 to 12 and \$7 from 12 to 14.

Theres more values than this, but if i can get this formula, i should be able to figure out the rest.

So for example here are the values...

at 90%
from 10 to 12 = 5
from 12 to 14 = 7

at 93%
from 10 to 12 = 6
from 12 to 14 = 8

Pleaase help, thanks a million in advance.

### Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

#### slicerdh

##### New Member
Try this in B3

=if(a1>90,if(b2=14,7,if(b1=12,5,0)),0)

Hope this helps

#### facethegod

##### Well-known Member
Try..but still don't know what you want for:

90-12-12
90-12-14
93-12-12
93-12-14

=CHOOSE(MATCH(A1,{90,93},0),IF(B1=10,LOOKUP(C1,{12,5;14,7}),LOOKUP(C1,{12,0;14,7})),IF(B1=10,LOOKUP(C1,{12,6;14,7}),LOOKUP(C1,{12,0;14,7})))

#### jumboh

##### New Member

This is a commission project... need the formula to go in B3.

A1 will have values... (90, 93) this is save percentage
B1 will have values... (10, 12) current rate for an account
B2 will have values... (12, 14) what the rep upgrades the account to.
B3 = ??? (commission)

If a rep save % is at 90 and upgrades a \$10 account to a \$12 he gets \$5, to a \$14, he gets \$7 etc. But if save percentage is at 93% he gets \$6 to go from 10 to 12 and \$7 from 12 to 14.

Theres more values than this, but if i can get this formula, i should be able to figure out the rest.

So for example here are the values...

at 90%
from 10 to 12 = 5
from 12 to 14 = 7

at 93%
from 10 to 12 = 6
from 12 to 14 = 8

Pleaase help, thanks a million in advance.

I'm sorry, but I put wrong cells in my question, it should read the following, but I think I can figure it out with the formulas you gave me. thank you, i will try these formulas and report back if it works tonight:

A1 will have values... (90, 93) this is save percentage
A2 will have values... (10, 12) current rate for an account
B2 will have values... (12, 14) what the rep upgrades the account to.
C2 = ??? (commission)

If a rep save % is at 90 and upgrades a \$10 account to a \$12 he gets \$5, to a \$14, he gets \$7 etc. But if save percentage is at 93% he gets \$6 to go from 10 to 12 and \$7 from 12 to 14.

Theres more values than this, but if i can get this formula, i should be able to figure out the rest.

So for example here are the values...

at 90%
from 10 to 12 = 5
from 12 to 14 = 7

at 93%
from 10 to 12 = 6
from 12 to 14 = 8

#### jumboh

##### New Member
Try..but still don't know what you want for:

90-12-12
90-12-14
93-12-12
93-12-14

=CHOOSE(MATCH(A1,{90,93},0),IF(B1=10,LOOKUP(C1,{12,5;14,7}),LOOKUP(C1,{12,0;14,7})),IF(B1=10,LOOKUP(C1,{12,6;14,7}),LOOKUP(C1,{12,0;14,7})))

This works. Thank You!!!

#### jumboh

##### New Member
wow, even with the above formula, I am still not able to make it work with what I am trying to do. I guess this is a very advanced formula. But I reposted my project with the exact data I will be using on this page:

Any help would be greatly appreciated.

Replies
8
Views
677
Replies
5
Views
1K
Replies
4
Views
312
Replies
13
Views
344
Replies
3
Views
189

1,190,870
Messages
5,983,321
Members
439,839
Latest member
iblackie

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back