Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    St. John's, NFLD

    Question Unanswered: Help with Combining IF with ISERROR statements

    Hello, Just wondering if any one would have a quick fix solution, I've been looking at this for what seems hours??

    I want to combine these 2 lines into one, but cant seem to do it.

    =IF(ISERROR(ROUNDUP(MAX(M15:M18), 2)), "NA", (ROUNDUP(MAX(M15:M18), 2)))

    =IF('Step 1'!B7>10,'Step 1'!D10*ROUNDUP(MAX(M15:M18), 2), IF('Step 1'!B7<=10,ROUNDUP(MAX(M15:M18), 2)))

    Basically I want the ISERROR to cover off the parameters B7>10 and B7<=10 and their resultant calculations. So it might look something like this:

    =IF(ISERROR(IF('Step 1'!B7>10,'Step 1'!D10*ROUNDUP(MAX(N15:N18), 2), IF('Step 1'!B7<=10,ROUNDUP(MAX(N15:N18), 2)), "NA", ('Step 1'!B7>10,'Step 1'!D10*ROUNDUP(MAX(N15:N18), 2), IF('Step 1'!B7<=10,ROUNDUP(MAX(N15:N18), 2))))

    Thanks for any help I can get! This seems very tricky!

    P.S. Both these lines work independently I just want to be able to combine them into one.

  2. #2
    Join Date
    Mar 2004
    Fort Worth, Texas, USA
    Is it feasible to put a function in N15:N18 that ensures a value is always present? That would simplify the logic in your calculation cell, i.e.

    =IF(MAX(N15:N18)<10, do this, do that)

  3. #3
    Join Date
    Dec 2003
    San Diego, CA
    Welcome to the Board!

    Why don't you post your workbook (.zip) and someone can take a look at it. A lot of your formula seems erroneous and the ISERROR can cause you more problems than you want if the formula isn't debugged to begin with.

    Try removing the ISERROR portions, then nest the formulas. If you really want the ISERROR after that, add it back in once the formula works.

    Hope that helps,


Posting Permissions

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