I have read some help topics on how to suppress the error message: #DIV/0!
However, the formula in the cell that I want to suppress the error message is a bit complicated. How would I suppress the above error message in this formula, and to show " --" instead?
=COUNTIF(S6:U8,"X") / (COUNTIF(S6:U8, "X") + COUNTIF(P6:R8,"X"))
The above formula calculates a percentage in a series of merged cells.
Thanks.
PG
Bookmarks