Transition Formula Evaluation

[radio848]

Hey all:
While implimating some of the formula tricks and valuable lessons that i am
learning in thiese newsgroups, i came across a little problem. "Transition
Formula Evaluation". Some of my file have this turned on, and when i enter
one of the formulae that i learned about, i get, "#value. when i turn the
function off, the formulae work just fine. is there anything that i am doing
wrong? i noticed that in one file, i was using the conditional formatting
function, to change the color of a cell and display a message.

 

[Harlan Grove]

While implimating some of the formula tricks and valuable lessons that i am
learning in thiese newsgroups, i came across a little problem. "Transition
Formula Evaluation". Some of my file have this turned on, and when i enter
one of the formulae that i learned about, i get, "#value. when i turn the
function off, the formulae work just fine. is there anything that i am doing
wrong? i noticed that in one file, i was using the conditional formatting
function, to change the color of a cell and display a message.

'Transition' means transition from Lotus 123. Excel (and close clones such as
OpenOffice/StarOffice) is mostly unique in automatically converting numbers
between numeric values and their text representations. That's why Excel allows
you to do things like (1+3)&".0" to get the string "4.0", and ((1+3)&".0")*5 to
get the numeric value 20. 123 most definitely didn't work this way. Both of the
preceding expressions return ERR in 123 and #VALUE! in Excel with Transition
Formula Evaluation enabled.

Unless you have a very clear need for Transition Formula Evaluation, you should
disable it.

 

[radio848]

Harlan: Thank you much. I am going to have to go through a lot of "STUFF",
all of which are to do with home budgeting and record keeping, and change
the way i am doing things. Thanks again..