C cruser Jan 20, 2009 #1 I have columns and rows of pieces and I need to write formula to balance or show "err" if not in balance
I have columns and rows of pieces and I need to write formula to balance or show "err" if not in balance
G Gord Dibben Jan 20, 2009 #3 =IF(A1=B1,"balanced", "err") entered in C1 and copied down. Gord Dibben MS Excel MVP
D dleo Jan 20, 2009 #4 cruser said: I have columns and rows of pieces and I need to write formula to balance or show "err" if not in balance Click to expand... Use an IF function. For example, =IF(A1=B1, TRUE, ERR)
cruser said: I have columns and rows of pieces and I need to write formula to balance or show "err" if not in balance Click to expand... Use an IF function. For example, =IF(A1=B1, TRUE, ERR)
