Confirm target cell is equal

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

A1 = 100

B1+C1 = 100

If B1+C1 = 100 less or more than A1 what should I include in the formula?

Or Conditional Formatting be a better way?

Thank you for any an all help.
Pat
 
Hi
not really sure what you're trying to do.< Do you mean
=IF(B1+C1=A1,"Equal","not equal")
 
That will do just nicely Frank, thanks.

Cheers

Frank Kabel said:
Hi
not really sure what you're trying to do.< Do you mean
=IF(B1+C1=A1,"Equal","not equal")
Click to expand...
 
You must log in or register to reply here.

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

Sumif less than x 3
Target cell reference moves when target is cut and pasted 5
formula help 2
If Formula for displaying a message 7
Conditional Format Range of Cells 3
copy and paste the cell with formula ="1" 3
Format of cell 1
highest second highest and third highest 6

Back
Top