Simple "IF" problem that I don't understand.

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

When I've opened an old Excel 97 spreadsheet in Excel 2000 an expression
which is used to test the value of a pull-down "switch" does not work
correctly (it still works ok in Excel 97). I must admit that I'm a
relatively new user to Excel and I have found a way around this but I don't
understand the result from the following command but I would like to
understand why it doesn't work;

=if(A2="On","The switch is on",if (A2 = "Off","The switch is
off","Unknown"))

It appears to work ok except when the cell (A2) is empty. The result is
then "The switch is on". This is not what I was expecting!!

Thanks for any reasons/suggestions.

Terry
 
Try turning off a lotus toggle:

Tools|Options|Transition Tab
Uncheck Transition formula evaluation

(That's a fun one to chase down, huh?)
 
Back
Top