You are currently offline, waiting for your internet to reconnect

How Transition Formula Entry Affects Behavior in MS Excel

This article was previously published under Q141764
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
When the Transition Formula Entry check box is selected, MicrosoftExcel allows you to enter and evaluate formulas in a manner moreconsistent with the behavior of Lotus 1-2-3.

The Transition Formula Entry option allows you to open Lotus 1-2-3files without losing or changing information. Note that whenever aLotus 1-2-3 file is opened in Microsoft Excel, these options areautomatically turned on.
To enable the Transition Formula Entry options, click Options on theTools 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 convertsformulas entered with Lotus 1-2-3 release 2.2 syntax to MicrosoftExcel syntax and makes names defined in Microsoft Excel behave asdefined names behave in Lotus 1-2-3.

In addition, if the Transition Formula Evaluation check box isselected, when Microsoft Excel evaluates formulas, text strings areconverted to 0, Boolean expressions are converted to 0 or 1, anddatabase criteria are converted according to the rules used in Lotus1-2-3.
8.00 97 TFE XL

Article ID: 141764 - Last Review: 08/17/2005 18:18:57 - Revision: 1.3

Microsoft Excel 97 Standard Edition, Microsoft Excel 95 Standard Edition

  • kbinfo kbualink97 KB141764
ml>/html> var varAutoFirePV = 1; var varClickTracking = 1; var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write("