=IF(A1=B1,"balanced", "err")

entered in C1 and copied down.


Gord Dibben MS Excel MVP

On Tue, 20 Jan 2009 13:31:03 -0800, cruser
wrote:

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