=c1=c2 gives number instead of true or false?

  • Thread starter Thread starter dave
  • Start date Start date
D

dave

I'm comparing 2 values by saying =c1=c2 and it gives me a
result of 1 or 0 instead of true or false. How did this
happen?

tia,
Dave
 
Dave

Tools>Options>Transition. Uncheck "transition formula evaluation".

Unless you are an ex-Lotus user, uncheck all the "transition" items.

Gord Dibben Excel MVP
 
thanks. Do you know what would cause that to be checked?
I've never seen it in 1000's of spreadsheets.
 
Dave

I suppose it could have been altered by some code in a workbook, but the most
common reason is that a user has inadvertantly enabled the checkbox.

The setting is saved with the workbook......not a global setting.

Gord
 
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 VBA - counting cells by colors and names to it in two different rows. 0
Value if two cells are true 2
copy and paste the cell with formula ="1" 3
how to use pivot data in formula or fuctions? 1
Excel How to get output of the formula instead of True or false 1
How is "A1<=A2<=A3" evaluated? 1
Pivot table consolidation 1
Excel repatation of Formula 8

Back
Top