Microsoft KB Archive/50276

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

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)