Question 4-20-23--Excel

Occasional Contributor

Good Morning Excel Community,


Need some assistance in resolving the following issue I have with a model that was past on to me.

For whatever reason when i utilized a formula to confirm if a cell = another cell, instead of getting a True or False result, i am getting 1 or 0.


there has to be a command or a turn on or off command , can someone please provide some instructions or how to in resolving this matter.   thanks.

3 Replies
best response confirmed by Hans Vogelaar (MVP)


Clear this check:



Thank you Patrick, worked like a charm.
You're welcome!