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

    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
    Location
    Fort Worth, Texas, USA
    Posts
    68
    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
    Location
    San Diego, CA
    Posts
    153
    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,

    Smitty

Posting Permissions

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