I am creating a table to calculate Ontario Employer Health Tax. I need a formula that will delivers the following result in column D: If the amount in column C (which is a monthly cumulative gross payroll amount) is less than or equal to $450,000, then the result in column D is the monthly payroll amount. If the amount in column C is greater than $450,000, then the result in column D is the amount that brings column D to a maximum amount of $450,000. So far I have =IF(C6<=450000,B6,450000-C6), but this does not maximize column C at $450,000. Thanks!
Solved by T. L. in 26 mins