S
Shams
Folks,
I am trying to write an IF statement that will do the following:
It calculates a commission amount based on 3 level of Sales:
If Sales is < = $1,500, calculate 0.0025*1500
If Sales is < = $3,000, calculate 0.0045*3000
If Sales is > $3,000, calculate 0.0050* cell reference...
Now, this may look easy enough..here's the trick that needs to happen
Say, sales is $5,500..the commission calculated should be cumulative i.e.
0.0025 * 1500, + .0045*3,000 + .0050*(remainder amount)
What would be a clean way of doing this? I will appreciate any help. Thanks.
Regards,
Shams.
I am trying to write an IF statement that will do the following:
It calculates a commission amount based on 3 level of Sales:
If Sales is < = $1,500, calculate 0.0025*1500
If Sales is < = $3,000, calculate 0.0045*3000
If Sales is > $3,000, calculate 0.0050* cell reference...
Now, this may look easy enough..here's the trick that needs to happen
Say, sales is $5,500..the commission calculated should be cumulative i.e.
0.0025 * 1500, + .0045*3,000 + .0050*(remainder amount)
What would be a clean way of doing this? I will appreciate any help. Thanks.
Regards,
Shams.