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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple VLOOKUP in an IF statement 2
Word OLE to check spelling in text box 1
OLE Word spelling 0
Copy addition formula of non-consecutive horizontal cells 2
Searching the formula (not the value) for a text string 1
If function across sheets prints value of cell 4
Cell reference in formula string displays abbreviated value 2
Numerical value of logicals 4

Top