W
Wannano
I need to write a commission formula that will calculate a cell, but if the
amount
calculated is greater than 750, than cap it at the 750.
For example
A1 = Center type (Full or Partial) only Full is qualified for this calculation
B1 = Percentage attained (0 up)
B3 = Payout up to 100% (say 500 which would be the base target payout)
B4 = Payout up to 150, with a cap of 150% of B3
I need help writing a formula for cell B4. Cell B3 is if(B1>100%,500,0)
For B4 calculation, the person must be in a "Full" center and will be paid
anything in Cell B1 OVER 100% with a cap at 150% of target (B3).
ALL assistance is very much appreciated.
amount
calculated is greater than 750, than cap it at the 750.
For example
A1 = Center type (Full or Partial) only Full is qualified for this calculation
B1 = Percentage attained (0 up)
B3 = Payout up to 100% (say 500 which would be the base target payout)
B4 = Payout up to 150, with a cap of 150% of B3
I need help writing a formula for cell B4. Cell B3 is if(B1>100%,500,0)
For B4 calculation, the person must be in a "Full" center and will be paid
anything in Cell B1 OVER 100% with a cap at 150% of target (B3).
ALL assistance is very much appreciated.