calculation of exemption limit

[Shabbo]

Dear Sir,

If A+B+C is greater than or equal to 150,000 then column E12 should show 150000
If A+B+C is Less than 150,000 then column E 12 should show actual amount

 

[Nebu]

Try
=MIN(SUM(E6:E10),150000)

Thanks