My exact "text" statement is returning a value of 0 for false??

S

sharrison

I am inserting an exact statement in a spreadsheet to verify last names. I
am getting a value of 0 for false and 1 for true. I can not figure out how
to get it to show false and true. thanks
 

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

If statement for a range of cells 3
Excel How to get output of the formula instead of True or false 1
Value if an if statement is false 3
TRUE/FALSE STATEMENT 4
Error in Copying "Exact" Function 1
Detecting text and returning a value 6
VLOOKUP returning #N/A result 2
If a value is found return a true/false 4

Top