View Single Post
 
Old 08-30-2019, 01:08 PM
DonBerg68 DonBerg68 is offline Mac OS X Office 2016 for Mac
Novice
 
Join Date: Aug 2019
Posts: 1
DonBerg68 is on a distinguished road
Default 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
File Type: jpeg Excel Error- Cell B115.jpeg (37.3 KB, 17 views)
File Type: jpeg Excel Error- Cell B61 (Correct).jpeg (35.2 KB, 17 views)
File Type: jpeg Excel Error?.jpeg (34.5 KB, 17 views)
Reply With Quote