How Transition Formula Entry Affects Behavior in MS Excel

MORE INFORMATION

To enable the Transition Formula Entry options, click Options on the Tools menu, and then click the Transition tab. Under Sheet Options, select the Transition Formula Entry check box.

When Transition Formula Entry is selected, Microsoft Excel converts formulas entered with Lotus 1-2-3 release 2.2 syntax to Microsoft Excel syntax and makes names defined in Microsoft Excel behave as defined names behave in Lotus 1-2-3.

In addition, if the Transition Formula Evaluation check box is selected, when Microsoft Excel evaluates formulas, text strings are converted to 0, Boolean expressions are converted to 0 or 1, and database criteria are converted according to the rules used in Lotus 1-2-3.