Differences between Microsoft Excel and Lotus 1-2-3

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

ShowGeneral differences

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.).

ShowLotus 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

ShowMicrosoft 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

ShowLotus 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

ShowFeatures of the Excel window

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.

 
 
Applies to:
Excel 2003