C
cruser
I have columns and rows of pieces and I need to write formula to balance or
show "err" if not in balance
show "err" if not in balance
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
Tad light on detail!
G
Gord Dibben
=IF(A1=B1,"balanced", "err")
entered in C1 and copied down.
Gord Dibben MS Excel MVP
entered in C1 and copied down.
Gord Dibben MS Excel MVP
D
dleo
cruser said: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)
D
David Biddulph
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?
intended to put "ERR", with the quotes to define the text string?