displayed cell values

T

tomoutdoors

why do my logical formulas display a value of "1" or "0" instead of "TRUE" or
"FALSE"? this is only happening in some sheets, not all.
 
N

Niek Otten

Please give an example of your formulas and the values of the precedent
cells.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
B

Bob Phillips

Tom,

take a look at Tools>Options>Transition and see if the Transition Formula
Evaluation box is checked. If so, uncheck it.
 
Top