Confirm target cell is equal

Pat · Dec 8, 2004

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

Frank Kabel · Dec 8, 2004

Hi
not really sure what you're trying to do.< Do you mean
=IF(B1+C1=A1,"Equal","not equal")

Pat · Dec 8, 2004

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")