Maximum amount allowed

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)

The person will be paid anything in Cell B1 for 100 and up only. In
addition, they can earn over 100%, but capped at 150% of target.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top