Results 1 to 2 of 2

Thread: Sum(If formula problem when=<+> issue help needed

  1. #1
    Acolyte mkellycole's Avatar
    Join Date
    Nov 2015
    Posts
    23
    Articles
    0
    Excel Version
    2016

    Sum(If formula problem when=<+> issue help needed



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have an insurance spreadsheet that I am trying to get to work where there is a base amount of premium for each employee, a 2% co-pay and other variables for calculating total employee deductions.

    There are two lines for each person. Line one is the amount of baseline premium and the chosen premium. I am trying to calculate:

    Baseline -Employer pays 98%
    Over baseline - Employee pays for 100% over the baseline plus 2% of baseline premium
    If Employee chooses a plan that is lower by more than 2%, Employer pays 100%

    Line 2 is used to check the calculations in column B.

    Thee are some formulas used in the spreadsheet for looking for issues.

    NEED HELP!
    Attached Files Attached Files

  2. #2
    Acolyte mkellycole's Avatar
    Join Date
    Nov 2015
    Posts
    23
    Articles
    0
    Excel Version
    2016
    My ideal outcome and result would be one line per employee and create a pivot table each year when premiums update.

Posting Permissions

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