Results 1 to 6 of 6

Thread: Long nested IF statement

  1. #1

    Unhappy Long nested IF statement

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

    I need to do a nested IF statement that uses one table of rates with 11 rows to calculate against about 1000 rows of variables. The 11 rows are age-banded rates (<25, 25-29, 29-34, 35-39, etc.) and the 1000 rows are the ages of individual people. I need to multiply the appropriate rate for the specific age times the number of thousands in another column to develop a premium amount. I can get it to work with two IF statements but once I try to add the third, it fails.

    To recap, colunn a has age, column b has number of thousands coumn n has age bands for rates and column o has the rates for the age band. I've tried everything I can think of and I've tried to find examples on the 'net but no luck so far. Is there a better way to do this than an IF statement?

    Thanks so much!

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Mississauga, Canada
    Excel Version
    Excel 2016
    A little confusing to follow.. can you post a sample workbook... with no confidential info?

  3. #3
    I will try to post the spreadsheet example. This is my first post so I'm not quite sure how to do that. Hold on.......

  4. #4

    Long nested IF statement - sample file

    Here we go.
    Attached Files Attached Files

  5. #5
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Victoria, Canada
    Excel Version
    Microsoft Excel 2013

    In the green cells (column H) I added a numerical value to represent the age you have in column I of the sample sheet. In the yellow cells (column F) I use a VLOOKUP formula to find the IRS Rate, then multiply by the salary.

    dc1TN 2012-04-25.xlsx


  6. #6
    SHAZAAM! Thanks very much.

    Be blessed

Posting Permissions

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