Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jul 2006
    Location
    Bangalore, India
    Posts
    180
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Need Help of ISERROR Formul (Excel 2003)

    Hi Excel Expert,

    I use the following formula to find the median of Various Departments. I have a list in Cell B1 where I select the Department and I get the median at various levels. I have used the ISERROR for the same at it works fine. However when I Select "ALL" i need an additional condition so that if there is a error it should display 0. I tried my best but not able to add the additional condition.

    {=IF($B$1="All",MEDIAN(IF('Master Data'!$AA$2:$AA$2094=$A49,'Master Data'!$AD$2:$AD$2094)),IF(ISERROR(MEDIAN(IF(('Mast er Data'!$AA$2:$AA$2094=$A49)*('Master Data'!$H$2:$H$2094=$B$1),'Master Data'!$AD$2:$AD$2094))),"",MEDIAN(IF(('Master Data'!$AA$2:$AA$2094=$A49)*('Master Data'!$H$2:$H$2094=$B$1),'Master Data'!$AD$2:$AD$2094))))}

    Can someone help me fix this.

    Thanks
    Baiju

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

    Re: Need Help of ISERROR Formul (Excel 2003)

    Does this do what you want?

    {=IF($B$1="All",IF(ISERROR(MEDIAN(IF('Master Data'!$AA$2:$AA$2094=$A49,'Master Data'!$AD$2:$AD$2094))),0,MEDIAN(IF('Master Data'!$AA$2:$AA$2094=$A49,'Master Data'!$AD$2:$AD$2094))),IF(ISERROR(MEDIAN(IF(('Mas ter Data'!$AA$2:$AA$2094=$A49)*('Master Data'!$H$2:$H$2094=$B$1),'Master Data'!$AD$2:$AD$2094))),"",MEDIAN(IF(('Master Data'!$AA$2:$AA$2094=$A49)*('Master Data'!$H$2:$H$2094=$B$1),'Master Data'!$AD$2:$AD$2094))))}

  3. #3
    2 Star Lounger
    Join Date
    Jul 2006
    Location
    Bangalore, India
    Posts
    180
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Need Help of ISERROR Formul (Excel 2003)

    Thanks Hans,

    This is exactly what i was looking for.. i have been struggling with this for sometime now

    Regards
    Baiju

Posting Permissions

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