error formula

  • Thread starter Thread starter cruser
  • Start date Start date
C

cruser

I have columns and rows of pieces and I need to write formula to balance or
show "err" if not in balance
 
=IF(A1=B1,"balanced", "err")

entered in C1 and copied down.


Gord Dibben MS Excel MVP
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sorted running balance 2
Multi-demensional frequency distribution 4
Access Running Balance in Access 1
Total formula 1
Paste without overwriting formulas 1
formula required (2nd time) 6
Excel Need aid in Excel Formulas 3
Auto-adjusting Formulas 1

Back
Top