The suggested formula would fail unless ERR had been defined. You may have
intended to put "ERR", with the quotes to define the text string?
--
David Biddulph

"dleo" wrote in message
...

"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)