Jump to content

Search the Community

Showing results for tags 'Excel if statement with 5 con'.

  • Search By Tags

    Type tags separated by commas.

  • Search By Author

Content Type


Forums (Message Boards)

  • Retirement Plans
    • 401(k) Plans
    • Defined Benefit Plans, Including Cash Balance
    • Retirement Plans in General
    • Distributions and Loans, Other than QDROs
    • IRAs and Roth IRAs
    • 403(b) Plans, Accounts or Annuities
    • Cross-Tested Plans
    • Correction of Plan Defects
    • SEP, SARSEP and SIMPLE Plans
    • Qualified Domestic Relations Orders (QDROs)
    • Employee Stock Ownership Plans (ESOPs)
    • Plan Terminations
    • Governmental Plans
    • Plan Document Amendments
    • 457 Plans
    • Investment Issues (Including Self-Directed)
    • Operating a TPA or Consulting Firm
    • Estate Planning Aspects of IRAs and Retirement Plans
    • Continuing Professional Education
    • ERPA (Enrolled Retirement Plan Agent)
  • Issues Spanning Multiple Types of Plans
    • Form 5500
    • Communication and Disclosure to Participants
    • Litigation and Claims
    • Church Plans
    • Securities Law Aspects of Employee Benefit Plans
    • Mergers and Acquisitions
    • Multiemployer Plans
    • International, Expat Benefits
    • Miscellaneous Kinds of Benefits
  • Health & Welfare Plans
    • Cafeteria Plans
    • Health Plans (Including ACA, COBRA, HIPAA)
    • Health Savings Accounts (HSAs)
    • VEBAs
    • Other Kinds of Welfare Benefit Plans
  • Executive Comp; Section 409A
    • 409A Issues
    • Nonqualified Deferred Compensation
  • Miscellany
    • Using the Message Boards (a.k.a. Forums)
    • Employee Benefits Job Opportunities
    • Humor, Inspiration, Miscellaneous
    • Computers and Other Technology
  • User Groups (Unofficial)
    • ftwilliam.com
    • Relius Administration

Find results in...

Find results that contain...


Date Created

  • Start

    End

Last Updated

  • Start

    End

Filter by number of...

Joined

  • Start

    End

Group

Website URL

Interests

Found 1 result

  1. AdKu
    I'm trying to improve a prospect check spreadsheet by adding DB/DC Gateway test check. But my if statement multiple conditions is not working for me. please help. If the plan has only HCEs or NHCEs - "NO REQUIRED GT" as in the first if clause If the plan is only DC then GT can be satisfied if all eligible ee receive at least 5% as in the 2nd if clause Otherwise, it will perform the GT check for DB/DC combo plan (given in the below table) as in the last five if clauses. HCE Gateway limit 1/3 to 5% 15-25% 6% 25-30% 7% 30-35% 7.50% >35% =IF(OR(A1=0,B1=0,C1=0),"NO REQUIRED GT", IF(AND('Table'!A2=2,U22>=0.05),"GT PASSES", IF(AND(U22>=0.075,'Table'!A2=1),"GT PASSES", IF(AND(T21>30,T21<=35,U22>=0.07, 'Table'!A2=1),"GT PASSES", IF(AND(T21>25,T21<=30,U22>=0.06, 'Table'!A2=1),"GT PASSES", IF(AND(T21>15,T21<=25,U22>=0.05, 'Table'!A2=1),"GT PASSES", IF(AND(T21<15,U22>=T21/3),"GT PASSES", "GT FAILED")))))))
×
×
  • Create New...

Important Information

Terms of Use

  I accept