+ Reply to Thread
Results 1 to 3 of 3

IF function with multiple conditions

  1. #1
    Registered User
    Join Date
    04-17-2014
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    4

    IF function with multiple conditions

    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!

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,697

    Re: IF function with multiple conditions

    for instance:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    or
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    04-17-2014
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: IF function with multiple conditions

    Thank you! Did not realize I could just combine IF functions like that.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. If Then function with Multiple conditions
    By DaBrot791 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-07-2012, 04:28 AM
  2. Multiple conditions for if function
    By jiyan200 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-12-2012, 11:12 AM
  3. multiple conditions on an If function.
    By hedgefund in forum Excel General
    Replies: 1
    Last Post: 04-21-2010, 09:42 PM
  4. Looking for a function for multiple conditions
    By MrSales in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-16-2007, 03:27 PM
  5. If Function with Multiple Conditions
    By tlosgyl3 in forum Excel General
    Replies: 6
    Last Post: 07-10-2006, 08:29 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1