Exculde some values

Could you kindly post your "CPT Input gef.xlsx" workbook, please?  I tried substituting CPT Input, but that is throwing up errors trying to define each element of qcza and fs.

Stuart

Why don't you just use "try... on error...." in the calculation of R ?

BTW, writing 100% has no effect, its just a multiplication by the number 1.

If you wan the result to be displayed as % value, you have to format the result accordingly.

The gef Excel workbook cleared up the initial errors..  There are quite a few further down the Mathcad worksheet, though.  More importantly, there are only 26 pages, so page 28 has gone walkabout.  I couldn't find an area in the Mathcad worksheet that looked like the above, either - although I might have missed it.   Can you check please check that the Mathcad worksheet you posted is the same one that has the problem? (I've sometimes been guilty of not saving a worksheet before posting it, so these things can happen)

Stuart

Maybe this helps.

No need for a 28 page worksheet which takes long to load, takes long to finish calculating and does not contain the problematic region at all!

Better for future questions: Create a small(!!!) worksheet with dummy data which shows the very same error!