Published on 03/28/2007

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, and the value of certain logical operators.

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

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

More Similar Functions

@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