multiple conditional IF AND

[jumboh]

cant find answer, tried for 4hrs, please help this noob. thanks in advance.

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.

 

[slicerdh]

Try this in B3

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

Hope this helps

 

[facethegod]

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]

cant find answer, tried for 4hrs, please help this noob. thanks in advance.

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]

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]

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:

http://www.mrexcel.com/forum/showthread.php?p=1593090#post1593090

Any help would be greatly appreciated.