Maximum amount allowed

[Guest]

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.

 

[Don Guillett]

Have a look in the help index for MAX