IFERROR on a spreadsheet for a long Formula

like this... =IFERROR(B3/((your formula)),"") should work.

I'm getting an "invalid attachment" message trying to open your attachment.
if the above is a "snippet" and that is what you believe is causing you errors, I put this in a cell
=IFERROR(B3/(($N3*$N$2)+($O3*$O$2)+($P3*$P$2)+($Q3*$Q$2)+($R3*$R$2)+($S3*$S$2)),0)
and instead of #DIV/0 I get 0, if I change it to
=IFERROR(B3/(($N3*$N$2)+($O3*$O$2)+($P3*$P$2)+($Q3*$Q$2)+($R3*$R$2)+($S3*$S$2)),"") it returns blank.
so there must be more to your issue and I / we can't tell from the snippet so a workbook uploaded with sample data AND expected results would be helpful.
Go Advanced (below this quick reply window) then manage attachments part way down, then browse, upload, close and submit reply to upload a workbook.

BTW, if you put the zero between quotes it will change the output of that snippet to text so leave the quotes out.

no, it would be more like this...
=IFERROR(B3/(($N3*$N$2)+($O3*$O$2)+($P3*$P$2)+($Q3*$Q$2)+($R3*$R$2)+($S3*$S$2))=B3/(($N3*$N$2)+($O3*$O$2)+($P3*$P$2)+($Q3*$Q$2)+($R3*$R$2)+($S3*$S$2)),0)
BUT, I'm not sure what you want to do with that formula? You are saying that if this (group of cells and formula applied) equals (the same group of cells and formula applied) otherwise return 0? Any group of cells with a formula applied will be equal to that group of cells with that formula applied.

Ok, N through S is giving six days. From your data how would you know in N through S that someone was missing (is that for one person or for a whole unit/dept)? What is the difference in looking at row 7 (N through S) vs row 2? Does row 7 indicate someone wasn't here but row 2 indicates all (or someone) was here for 5 days? I / we can devise an easier formula to determine if someone was here or not for those 5 (or is it 6) days if that is what you need. But that formula as I noted before makes no sense, as I wrote, it is simply does this equal itself which will always be true (unless in your case you are dividing by zero then you will get the error first, but when you correct that error you'll always get true as long as there are values in N through S and a value in B.

Lastly, AND maybe this is the fix you need, this is what your formula should look like U3 should be and maybe this is all you need?
=IFERROR(B3/(($N3*$N$2)+($O3*$O$2)+($P3*$P$2)+($Q3*$Q$2)+($R3*$R$2)+($S3*$S$2)),0)
get rid of the equal to itself part.

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.