Can I set a maximum value on top of and IF sum?

[UniAmyColeman]

Hi All

So I am using the following formula to calculate payment entitlements:

=IF(L145="Scheme A",P145*30,P145*60)

So Scheme A pays £30 per day and Scheme B pays £60 a day (in the above if Column L contains "Scheme A" it multiplies P by 30, if L doesn't contain "Scheme A" then P by 60) . This works fine. But....

Column P contains the number of days that the participants are on scheme. The payment maximum is for 10 days but Column P could contain a value more than 10.

So my question is can I use my above formula but somehow have an up to a maximum of £300 or £600? Or do you know of an alternative way to achieve this?

Hope that makes sense. Any advice welcome

Best wishes

Amy

 

[AlanY]

try

=MIN(10,P145)*IF(L145="Scheme A",30,60)

 

[Finalfight40]

If i read it correctly, is this what you are after?

=IF(L145="Scheme A",30,60)*If(P145>10, 10, P145)

 

[UniAmyColeman]

=IF(L145="Scheme A",30,60)*If(P145>10, 10, P145)

This works perfectly, thank you