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.