Hello all,

I am setting up a page to calculate employer share of CPP, EI etc - there is a max. we have to pay on some employees and not others.

Salary x employer CPP rate (4.95%)= if over 1300, I want it to state $1300 as that is the max we would have to pay (even if the actually figure is $1500) - if it is under I want it to say the actual figure.

Can this all be done in one cell?


thanks so much!