True/False Error

		Microsoft Office Forums > Microsoft Excel > Excel
True/False Error

FAQ

Thread Tools

Display Modes

08-30-2019, 01:08 PM

DonBerg68

Mac OS X

Office 2016 for Mac

Novice

Join Date: Aug 2019

Posts: 1

True/False Error

I am using a simple if formula, but the results being returned in two cases are incorrect as far as I can tell.

I am attaching screenshots of the two cells returning the error and one of the same formula returning the correct result.

WTF?

Is there something about the values that I can't see? I tried changing the cell format to general or number, but the contents still displayed values that look equal to me and still displayed the False indicator "???".

Attached Images

	Excel Error- Cell B115.jpeg (37.3 KB, 19 views)
	Excel Error- Cell B61 (Correct).jpeg (35.2 KB, 19 views)
	Excel Error?.jpeg (34.5 KB, 19 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data Compare and result as true or false in result sheet	aligahk06	Excel	1	08-29-2019 06:44 AM
Converting a 1 or 0 into TRUE or FALSE?	ayupchap	Mail Merge	1	04-25-2017 02:45 PM
Can you do True or False equations in Excel?	WisCowboy	Excel	1	02-05-2016 04:53 PM
Task Indicator - All predecessors complete true/false, y/n	jdove78	Project	2	10-10-2012 05:53 PM
Mail Merge Function not Noticing 'True' vs. 'False' Statement	danellekent	Mail Merge	1	04-27-2012 02:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:13 AM.