John D.

asked • 05/16/18

How do I show true/false/nothing in a cell?

For example, column3 should show true false or nothing if it matches a value in column 1. If column 1 doesn't have a value, then I don'tw ant column 3 to show anything.

Gregory T.

You should use an If statement like "=if(a1="","",a1=b1,"true","false")
I'm assuming by "it" you meant a value in column 2 (b1).  If you mean something else, please be more specific.
Report

05/16/18

Gregory T.

Sorry, I was distracted.  The formula should be:  "=if(a1="","",if(a1=b1,"true","false"))).
Report

05/16/18

Michael H.

I have colum1 in D, column 2 in E, column 3 in F.

So, you have values in 1 and 2.
My formula in column 3, for row 4 is:

=IF(E4=D4, "True",IF(E4="","","False"))
Report

05/16/18

1 Expert Answer

By:

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.