Entering Formulas – =

Topic

New Reply

Is there a way to enter simple formulas like b1+c1 or 150-25 without first entering an = sign?

Reply | Quote

Replies

The only way I know is +b1+c1 or +150-25

I susoect that doesn’t help you much though.

Reply | Quote

Try: Tools / Options / Transition / Transition Formula Entry

Using the help button on the Options form states that this option:
“Converts formulas entered in Lotus 1-2-3 release 2.2 syntax to Microsoft Excel syntax, and makes names defined in Microsoft Excel behave like names defined in Lotus 1-2-3.”

Check the option box and type 1+2+3 into a cell and hit Enter, and Excel automatically insert a = into the formula and return a value of 6, instead of returning the undesired text string.

This is good for entering simple formulas, but it can also cause some undesired results. This is particularly true when keying in dates or other numerical-looking data that contain operator-type characters. Keying 3/7/01 results in 0.428571 instead of the date; 800-555-1212 yields -967.

Reply | Quote

Thanks. That is what I was looking for.

Reply | Quote