# Differences between Microsoft Excel and Lotus 1-2-3

Some of the content in this topic may not be applicable to some languages.

**Select first, then choose a command** In Lotus 1-2-3, you choose a command and then specify a range that the command will affect. In Excel, you select the cell, range, or object you want to work with and then choose a command to perform an action. For example, if you want to format a range of cells, select the cells and then click **Cells** on the **Format** menu.

**Keys for moving around a worksheet** The navigation keys you use to move around a worksheet differ between Excel and Lotus 1-2-3. For example, if you press the HOME key in Lotus 1-2-3, the cell in the upper-left corner of the worksheet is selected; in Excel, the first cell of the current row is selected. You can change the navigation keys in Excel to move around the worksheet in the same way as Lotus 1-2-3.

**Parsing text from one column to several** In Lotus 1-2-3, you use the **Parse** command to separate text strings in one column across several columns. When you open a text file in Excel, the Text Import Wizard will assist you in parsing the data into columns. If you need to parse data in one column across several columns on the worksheet, use the **Text to Columns** command (**Data** menu).

**Macros** Excel 2000 and later versions of Excel do not run Lotus 1-2-3 macros. If you want to rewrite Lotus 1-2-3 macros for Excel, see Visual Basic Help (Microsoft Visual Basic Help: To get help for Visual Basic in Excel, point to **Macro **on the **Tools** menu, and then click **Visual Basic Editor**. On the **Help** menu, click **Microsoft Visual Basic Help**.).

Lotus 1-2-3 functions that have equivalent Microsoft Excel functions

Many Lotus 1-2-3 functions have Microsoft Excel equivalents. However, Microsoft Excel uses different calculation rules than Lotus 1-2-3 when evaluating text in formulas, certain database criteria (criteria: Conditions you specify to limit which records are included in the result set of a query or filter.), and the value of certain logical operators (operator: A sign or symbol that specifies the type of calculation to perform within an expression. There are mathematical, comparison, logical, and reference operators.).

Lotus function |
Equivalent function in Microsoft Excel |
---|---|

@@ | INDIRECT |

@ABS | ABS |

@ACOS | ACOS |

@ASIN | ASIN |

@ATAN | ATAN |

@ATAN2 | ATAN2 |

@AVG | AVERAGEA |

@CELL | CELL |

@CELLPOINTER |
CELL When used without a second argument, the CELL worksheet function returns information about the cell containing the function. |

@CHAR | CHAR |

@CHOOSE | CHOOSE |

@CLEAN | CLEAN |

@CODE | CODE |

@COLS | COLUMNS |

@COS | COS |

@COUNT | COUNTA |

@CTERM |
NPER The NPER worksheet function requires you to supply a periodic payment value instead of a future value. |

@DATE | DATE |

@DAVG | DAVERAGE |

@DAY | DAY |

@D360 The @D360 function is available only in Lotus 1-2-3 Release 3 or later. |
DAYS360 |

@DCOUNT | DCOUNTA |

@DDB | DDB |

@DGET | DGET |

@DMAX | DMAX |

@DMIN | DMIN |

@DSTD | DSTDEVP |

@DSTDS | DSTDEV |

@DSUM The @DSTDS function is available only in Lotus 1-2-3 Release 3 or later. |
DSUM |

@DVAR | DVARP |

@DVARS The @DVARS function is available only in Lotus 1-2-3 Release 3 or later. |
DVAR |

@ERR | Microsoft Excel does not have an equivalent function. You can type error values such as #N/A and #VALUE! directly into cells and formulas in Microsoft Excel. |

@EXACT | EXACT |

@EXP | EXP |

@FALSE | FALSE |

@FIND | FIND |

@FV | FV |

@HLOOKUP | HLOOKUP |

@HOUR | HOUR |

@IF |
IF In Microsoft Excel, the last two arguments can be any value, or contain another worksheet function; they are not limited to numbers or strings, as in @IF. |

@INDEX |
INDEX The INDEX worksheet function has two forms, one to look up a referenced cell and one to select values from an array. |

@INT | TRUNC |

@IRR |
IRR The list of arguments for the IRR worksheet function is in reverse order of the arguments for the @IRR function. |

@ISERR |
ISERR The ISERR worksheet function detects any error value in Microsoft Excel except #N/A (#VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!). |

@ISNA | ISNA |

@ISNUMBER | ISNONTEXT |

@ISRANGE The @ISRANGE function is available only in Lotus 1-2-3 Release 3 or later. |
ISREF |

@ISSTRING | ISTEXT |

@LEFT | LEFT |

@LENGTH | LEN |

@LN | LN |

@LOWER | LOWER |

@LOG | LOG |

@MAX | MAXA |

@MID | MID |

@MIN | MINA |

@MINUTE | MINUTE |

@MOD | MOD |

@MONTH | MONTH |

@N | N |

@NA | NA |

@NOW | NOW |

@NPV | NPV |

@PI | PI |

@PMT |
PMT You supply the list of arguments for the PMT worksheet function in a different order than you do for the @PMT function. |

@PROPER | PROPER |

@PUREAVG The @PUREAVG function is available only in Lotus 1-2-3 Release 4 or later. |
AVERAGE |

@PURECOUNT The @PURECOUNT function is available only in Lotus 1-2-3 Release 4 or later |
COUNT |

@PUREMAX The @PUREMAX function is available only in Lotus 1-2-3 Release 4 or later. |
MAX |

@PUREMIN The @PUREMIN function is available only in Lotus 1-2-3 Release 4 or later. |
MIN |

@PURESTD The @PURESTD function is available only in Lotus 1-2-3 Release 4 or later. |
STDEVP |

@PURESTDS The @PURESTDS function is available only in Lotus 1-2-3 Release 4 or later. |
STDEV |

@PUREVAR The @PUREVAR function is available only in Lotus 1-2-3 Release 4 or later. |
VARP |

@PUREVARS The @PURVARS function is available only in Lotus 1-2-3 Release 4 or later. |
VAR |

@PV |
PV You supply the list of arguments for the PV worksheet function in a different order than you do for the @PV function. |

@RAND |
RAND The RAND worksheet function calculates values randomly each time the function is recalculated. The @RAND function calculates the same values in each work session. |

@RATE |
RATE You supply the list of arguments for the RATE worksheet function in a different order than you do for the @RATE function. |

@REPEAT | REPT |

@REPLACE | REPLACE |

@RIGHT | RIGHT |

@ROUND | ROUND |

@ROWS | ROWS |

@S | T |

@SECOND | SECOND |

@SIN | SIN |

@SLN | SLN |

@SQRT | SQRT |

@STD | STDEVPA |

@STDS | STDEVA |

@STRING | FIXED |

@SUM | SUM |

@SYD | SYD |

@TAN | TAN |

@TERM |
NPER You supply the list of arguments for the NPER worksheet function in a different order than you do for the @TERM function. |

@TIME | TIME |

@TIMEVALUE | TIMEVALUE |

@TODAY | TODAY |

@TRIM | TRIM |

@TRUE | TRUE |

@UPPER | UPPER |

@VALUE | VALUE |

@VAR | VARPA |

@VARS | VARA |

@VDB | VDB |

@VLOOKUP | VLOOKUP |

@YEAR | YEAR |

Microsoft Excel functions that do not have equivalent Lotus 1-2-3 functions

The following Microsoft Excel functions have no equivalents in Lotus 1-2-3 Release 3.1 or earlier, or in Lotus 1-2-3 for Windows Release 1.0. If you save a workbook in one of these formats, these functions are replaced with the resulting value of the function.

** Note ** This list does not include many Microsoft Excel add-in functions and statistical functions that do not have Lotus 1-2-3 equivalents.

Microsoft Excel function |
---|

AREAS |

DOLLAR |

DPRODUCT |

FACT |

FREQUENCY |

GETPIVOTDATA |

GROWTH |

INT |

HYPERLINK |

IPMT |

ISBLANK |

ISERROR |

ISLOGICAL |

LINEST |

LOGEST |

LOOKUP |

MATCH |

MDETERM |

MINVERSE |

MIRR |

MMULT |

PPMT |

PRODUCT |

SEARCH |

SUBSTITUTE |

TEXT |

TRANSPOSE |

TREND |

TYPE |

WEEKDAY |

Lotus 1-2-3 terminology and Microsoft Excel equivalent terms

The following table lists Lotus 1-2-3 terms and equivalent Microsoft Excel terms. The Excel term may not be an exact equivalent of the Lotus 1-2-3 term, but you can use it to look for more information in Help.

Lotus 1-2-3 term |
Microsoft Excel term or concept |
---|---|

@Function | Function |

Address | Reference |

Anchor cell | Selecting a range of cells |

Border | Row and column headings |

CALC indicator | Status bar |

Cell pointer | Active cell |

Column labels | Column headings |

Control panel | Menu bar, formula bar, status bar |

Copy | Copy and then paste |

Crosshatching | Chart patterns |

Current cell | Active cell |

Current worksheet | Active worksheet or chart sheet |

Cursor | Insertion point |

Data range | Data series |

Data table 1 | One-input data table |

Data table 2 | Two-input data table |

Date format | Number format |

Erase | Clear |

Formula criteria | Computed criteria |

Global | Workspace |

Graph | Chart |

Graph labels | Chart text |

Graph titles | Chart titles |

Highlight | Select or selection |

Indicator | Status bar |

Input range | List or range reference (for Analysis Tools) |

Label | Text |

Label-prefix | Horizontal alignment |

Label/matching criteria | Comparison criteria |

Logical 0 | FALSE |

Logical 1 | TRUE |

Menu pointer | Menu selection |

Mode indicator | Status bar |

Numbering/matching criteria | Comparison criteria |

Numeric format | Number format |

Output range | Extract range |

Picture file | Chart, chart sheet (no separate file) |

Pointer movement keys | Arrow keys |

Print range | Print area |

Protected cell | Locked/protected cell |

Range highlight | Selected range |

Repeating label | Horizontal fill alignment (Format menu, Cells command, Alignment tab) |

Retrieve a file | Open a file |

Row numbers | Row headings |

Stacked bar graph | Stacked Column chart, Stacked Bar chart, 100% Stacked Column chart, 100% Stacked Bar chart |

Status indicator, status line | Status bar |

String | Text |

Target cell | Dependent cell |

Target file | Dependent document |

Time format | Number format |

Titles | Split worksheet window with frozen panes |

Translate utility | Open and Save As commands on the File menu |

Value | Number |

Window | Multiple windows, pane |

Excel displays workbooks that contain worksheets in a window. By default, the menu bar, the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.), and the **Standard** and **Formatting** toolbars are displayed at the top of the window. At the bottom of the window, the status bar displays different indicators about the current working environment.