Hi,
I'm trying use a formula to automatically calculate CPP (Canada Pension Plan) contributions based on income earned.
The first $3,500 of income has no CPP contributions deducted and anything over $51,100 has a max contribution of $2,356.20.
Total income is in column B, CPP contributions are in column C. Right now the formula I have in C11 is:
=IF(B11>=$B$85, $C$85, (B11-3500)*0.0495)
0.0495 being the contribution rate.
B11=income
B85=51,100.00
C85=2,356.20
This formula does not factor in the fact that anyone who makes $3,500 or less will have $0 in CPP contributions. How can I add this condition in?
Thanks!
Bookmarks