Simple IF formula

[Guest]

Need formula using simple IF function. Involves using Gross pay and CPP deductions.Col.E2 is Gross Pay
Col. F2 is CPP deduction. Here is scenario. "CPP is 3.5% of the gross pay, to a maximum of $22. Hope someone out there can give me a hand. I've gone through a lot of reading, still no luck. Thanks

 

[CLR]

=MIN(F2*E2,22)

Vaya con Dios,
Chuck, CABGx3

Need formula using simple IF function. Involves using Gross pay and CPP

deductions.Col.E2 is Gross Pay,

Col. F2 is CPP deduction. Here is scenario. "CPP is 3.5% of the gross pay,

to a maximum of $22. Hope someone out there can give me a hand. I've gone
through a lot of reading, still no luck. Thanks

 

[Gord Dibben]

Bonnie

In F2 enter =MIN(22,0.035*E2)

Gord Dibben Excel MVP