This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
How do I get this formula to display True False instead of 1/0?
=A1=B1
I do not need additional, more complicated formuals. I can come up with those on my own.
What I'm looking for is the reason I get 1/0 instead of true/false. It works on other tabs in the spreadhseet and in other workbooks as expected but not on this one tab.
I've tried Text to Columns and other formatting options. I know this is setting related, I just don;t know how to fix it.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi,
It's a setting. I don't have Excel 365 but on mine it's
File _ Options _Advanced and scroll down and un-check 'Transition Formula Evaluation'.
You should also un-check 'Transition formula entry.
Thanks, it's one of the trivial bits of info that remain in my head from when my company transitioned from Lotus 123 to Excel.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
Thank you, but that does not answer my question. I specifically mentioned that I was not looking for additional formulas. It has to be a formatting issue that needs to be changed.
Hi,
=IF((A1=B1)=TRUE,1,0)