displayed cell values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Please give an example of your formulas and the values of the precedent
cells.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Tom,

take a look at Tools>Options>Transition and see if the Transition Formula
Evaluation box is checked. If so, uncheck it.
 
You must log in or register to reply here.

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

Excel How to get output of the formula instead of True or false 1
Numerical value of logicals 4
MATCH not working in IF statement 6
Calculation / Format Error 1
If function across sheets prints value of cell 4
Cell reference in formula string displays abbreviated value 2
Excel VBA 1
How do i trouble shoot an IF function 2

Back
Top