SOLVED

Question 4-20-23--Excel

Copper 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)
Solution

@elo0707 

Clear this check:

Patrick2788_0-1682001989329.png

 

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

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution