Microsoft Excel functions that have equivalent to Lotus 1-2-3 functions
- By Richard Richi
- Published 03/28/2007
- MS Excel
- Unrated
Richard Richi
View all articles by Richard Richi
| 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 |

