Thank you Dave. Updating that setting solved the problem.

"Dave Peterson" wrote:

Toggle this setting:

Tools|Options|Transition tab
Uncheck "Transition formula evaluation"

You may find it better to uncheck all those lotus 123 settings.

ExcelUser123 wrote:

How do I make the result of a true/false formula display as TRUE or FALSE
instead of 1 or 0?

--

Dave Peterson