This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi Folks
I'm having some difficulty in adding ISERROR into my nested formula...
=IF(AND(H380="Y",H6<>""),1,IF(H380="N/a","",IF(AND(H380="Y",H6=""),0,0)))
H6 being the cell with #DIV/0!
Many thanks
Tracey
Excel vs 2002
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Maybe.......
=IF(ISERROR(H6),"Error in H6",IF(AND(H380="Y",H6<>""),1,IF(H380="N/a","",IF(AND(H380="Y",H6=""),0,0))))
Vaya con Dios,
Chuck, CABGx3
Answer accepted by question author
Ok so now this is closed... I did a work around - I created a table replicating the pivot table (tbl1) with the formula**=IF(ISERROR(G6),"Nill",1)**
And then in table 3 I have the following formula: =IF(AND(G380="Y",AX6=1),1,IF(G380="N/a","",IF(AND(G380="Y",AX6="Nill"),0,0)))
It works! Long way round but it still works
Thank you Chuck and Bernard your suggestions helped a great deal!
Answer accepted by question author
=IF(ISERROR(H6),"H6 has an error",IF(AND(H380="Y",H6<>""),1,IF(H380="N/a","",IF(AND(H380="Y",H6=""),0,0))))
But I wonder about H380="N/a" Has the user typed "N/a" or is this coming from a formula? Perhaps that term should read H380=NA(), it ISNA(H380)
best wishes
people.stfx.ca/bliengme
it still brings back #DIV/0!
=IF(AND(H380="Y",H6<>""),1,IF(H380="N/a","",IF(AND(H380="Y",**H6=#DIV/0!),**0,0)))
Reduced formula
=IF(H380="N/a","",IF(ISERROR(H6),"What happens?",IF(H6="",0,1)))