Show All

Enter and evaluate formulas with Lotus 1-2-3 rules

1. On the Tools menu, click Options, and then click the Transition tab.
2. Do one of the following:
   • To enter formulas according to Lotus 1-2-3 rules, select the Transition formula entry check box. With the Transition formula entry option selected, Microsoft Excel applies names for ranges as you enter references to ranges in formulas. In addition, if a function does not require arguments, you can type @ followed by the Lotus 1-2-3 function name and the function is converted to its Excel equivalent.

   • To enter formulas according to Excel rules, clear the Transition formula entry check box.

3. Do one of the following:
   • To calculate formulas according to Lotus 1-2-3 rules, select the Transition formula evaluation check box.

   • To calculate formulas according to Excel rules, clear the Transition formula evaluation check box.

   Caution  Avoid alternately selecting and canceling the Transition formula evaluation option; otherwise, the values calculated on your worksheet might change.

4. Click OK.
5. Enter your formula.

Notes

• When you select and clear the Transition formula entry check box, formulas don't automatically reapply names or restore names to references.
• The Transition formula entry and Transition formula evaluation options remain active for a worksheet until you clear them, even if you save the Lotus 1-2-3 worksheet as an Excel worksheet.