"cruser" wrote:

I have columns and rows of pieces and I need to write formula to balance or
show "err" if not in balance

Use an IF function. For example, =IF(A1=B1, TRUE, ERR)