Assuming this is a question in Excel and not C#, you can key in this
formula in another cell.

Say you key in this formula in Cell N10:
=IF (ISNA(D10), 1, IF(ISERR(D10), 1, 0) )

then, whenever cell D10 gets a # error (such as #REF! #NA etc) cell
N10 will get a 1. If no error, cell N10 will be 0.

Hope this helps.
-feltra


On Jan 9, 9:33 pm, Andrew HUANG
wrote:
Hi, All,

Some cells may be error, such as #REF!. How to know which cell is in error?

Thanks,
-Andrew