Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Mechanicsville, Virginia, USA
    Posts
    130
    Thanks
    0
    Thanked 0 Times in 0 Posts

    IF(ISERROR (Excel 2003)

    Wondering if someone could assist me with inserting an IF(ISERROR statement into the formula below. I think that my problem is with the brackets, but can't be sure.

    {=AVERAGE(IF((CF_DateOut<=RDate)*(CF_DateOut>=FOW) ,(CF_ProcDays)))}

    Thanks!

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: IF(ISERROR (Excel 2003)

    It's a little hard to test without data, but try this syntax

    =AVERAGE(IF(ISERROR((CF_DateOut<=RDate)*(CF_DateOu t>=FOW)),0,CF_ProcDays))

    assuming you use Ctrl-Shift-Enter to turn it into an {array formula}.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Mechanicsville, Virginia, USA
    Posts
    130
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IF(ISERROR (Excel 2003)

    Oops...sorry that I did not attached the .xls. Question, when I added this formula to the cell, and the cell was formatted as a number, the end result was 0. If the cell was formatted as general, the formula appeared to calculate the entire range, and did not look at my date criteria (CF_DateOut,RDate). Is there a way to have the end result of this array provide me with an N/A?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: IF(ISERROR (Excel 2003)

    Does this do what you want (as an array formula)?

    =IF(SUM((CF_DateOut<=RDate)*(CF_DateOut>=FOW))=0," ",AVERAGE(IF((CF_DateOut<=RDate)*(CF_DateOut>=FOW) ,(CF_ProcDays))))

    to leave the result blank if the average results in an error, or

    =IF(SUM((CF_DateOut<=RDate)*(CF_DateOut>=FOW))=0,# N/A,AVERAGE(IF((CF_DateOut<=RDate)*(CF_DateOut>=FOW) ,(CF_ProcDays))))

    to display #N/A.

  5. #5
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Mechanicsville, Virginia, USA
    Posts
    130
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IF(ISERROR (Excel 2003)

    Hans,

    This is great!!! Thanks again.

Posting Permissions

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