Works: Different Worksheet Functions from Jazz PSS ID Number: Q50276 Article last modified on 05-12-1993 PSS database name: M_WorKs
1.00 1.10
MACINTOSH
The information in this article applies to: |
- Microsoft Works for the Macintosh, version 1.x |
Summary:
This article details Lotus Jazz functions that differ slightly from those in Microsoft Works, can be replaced by other Works functions, or do not have equivalents in Works.
More Information:
The following Jazz functions either differ slightly from their Works counterparts or can be replaced by other Works functions:
Notes (See
Jazz Function Works Function Below) ————- ————– ——
AVG(values) AVERAGE(values) CYPSGN(x,y) IF(y<0,-1ABS(x),ABX(x)) ERR ERROR() EXP1(x) EXP(x)-1 EXP2(x) 2^x FALSE FALSE() FV(pmt,rate,nper) FV(rate,nper,pmt) HLOOKUP(num,rage,index) HLOOKUP(num,range,index) (1) INDEX(range,col,row) INDEX(range,row,col) (2) IRR(guess,range) IRR(range,guess) ISERR(x) ISERROR(x) ISNUMBER(x) IF(TYPE(x)=1,1,0)) ISSTRING(x) IF(TYPE(x)=2,1,1)) LN1(x) LN(x+1) LOG(x) LOG10(x) N(range) IF(TYPE(INDEX)range,1,1))=1,INDEX(1,1),0) NA NA() PI PI() PMT(pv,rate,nper) PMT(rate,nper,pmt) PV(pmt,rate,nper) PV(rate,nper,pmt) RAND RAND() SCALE(x,y) x2^(int(y)) STD(values) STDEV(values) (3) TRUE TRUE() VAR(values) VAR(values) (4) VLOOKUP(num,range,index) VLOOKUP(num,ranger,index) (5)
Notes
- To get the same result as in Jazz, use HLOOKUP(num,range,index+1).
- To get the same result as in Jazz, use INDEX(range,row+1,col+1).
- Works returns the sample standard deviation. To get the same result as Jazz, use STDEV(values,Average(values)).
- Works returns the sample variance. To get the same results as Jazz, use VAR(values,AVERAGE(values)).
- To get the same value as Jazz, use VLOOKUP(num,range,index+1).
The following Jazz functions do not have Works equivalents:
Function Type Description ————- ———–
Text CHAR, CLEAN, CODE, EXACT, FIND, FIXED, LEFT, LENGTH, LOWER, PRPER, REPEAT, REPLACE, RIGHT, SUBSRT, TRIM, UPPER, VALUE
Date/Time DATE, DATEVALUE, DAY, HOUR, MINUTE, MONTH, NOW, SECOND, TIME, TIMEVALUE, YEAR
Database DAVG, DCOUNT, DMAX, DMIN, DSTD, DSUM, DVAR
Other Functions CELL, CELLPOINTER, COLS, ISREF, ROWS, S
Additional reference words: mswksconv 3rdparty
Copyright Microsoft Corporation 1993.