Microsoft KB Archive/50276

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 18:24, 12 August 2020 by X010 (talk | contribs) (X010 moved page Microsoft KB Archive/Q50276 to Microsoft KB Archive/50276 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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

  1. To get the same result as in Jazz, use HLOOKUP(num,range,index+1).
  2. To get the same result as in Jazz, use INDEX(range,row+1,col+1).
  3. Works returns the sample standard deviation. To get the same result as Jazz, use STDEV(values,Average(values)).
  4. Works returns the sample variance. To get the same results as Jazz, use VAR(values,AVERAGE(values)).
  5. 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.