IF(OR(ISERROR...(ISBLANK problem

[rustyy]

Hi There,
I'm also having difficulty with this type of formula, I suspect I just have the parentheses out of order? as this will return the result I require but it displays the #div/0 error instead of "".

I'm wanting the formula to display the results if there is no error or if G3 isn't blank.
This code uses values in table headings then counts the values on the data tab.


=IF(OR(ISERROR(COUNTIF(DATA!$A:$A,TEXT(G$3,"d/mm/yyyy")&"|"&IF($C8="Uncategorised","UC",RIGHT($C8,1))&"|Breach"))/(COUNTIF(DATA!$A:$A,TEXT(G$3,"d/mm/yyyy")&"|"&IF($C8="Uncategorised","UC",RIGHT($C8,1))&"|Breach")+COUNTIF(DATA!$A:$A,TEXT(G$3,"d/mm/yyyy")&"|"&IF($C8="Uncategorised","UC",RIGHT($C8,1))&"|No Breach")),(ISBLANK(G$3))),"",(COUNTIF(DATA!$A:$A,TEXT(G$3,"d/mm/yyyy")&"|"&IF($C8="Uncategorised","UC",RIGHT($C8,1))&"|Breach"))/(COUNTIF(DATA!$A:$A,TEXT(G$3,"d/mm/yyyy")&"|"&IF($C8="Uncategorised","UC",RIGHT($C8,1))&"|Breach")+COUNTIF(DATA!$A:$A,TEXT(G$3,"d/mm/yyyy")&"|"&IF($C8="Uncategorised","UC",RIGHT($C8,1))&"|No Breach")))


Any help would be appreciated

[arthurbr]

Hi and welcome to the board

Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

I have moved your post for you - Please have a look at our forum rules - Thx