Article ID: 242345
Article Last Modified on 1/25/2007
APPLIES TO
- Microsoft Works 2000 Standard Edition
- Microsoft Works 6.0
- Microsoft Works Suite 2000
- Microsoft Works Suite 2001
This article was previously published under Q242345
SUMMARY
This article contains a list of functions you can use in Microsoft Works.
For more information about these functions, please see Appendix A in your Microsoft Works User's Guide or online Help file.
MORE INFORMATION
The following list contains the functions and parameters available in Works Spreadsheet:
- ABS(x)
- ACOS(x)
- AND(Logical0,Logical1,...)
- ASIN(x)
- ATAN(x)
- ATAN2(x-coordinate,y-coordinate)
- AVG(RangeReference0,RangeReference1,...)
- CHOOSE(Choice,Option0,Option1,...)
- COLS(RangeReference)
- COS(x)
- COUNT(RangeReference0,RangeReference1,...)
- CTERM(Rate,FutureValue,PresentValue)
- DATE(Year,Month,Day)
- DAY(DateSerialNumber)
- DDB(Cost,Salvage,Life,Period)
- ERR()
- EXACT(TextValue0,TextValue1)
- EXP(x)
- FALSE()
- FIND(FindText,SearchText,Offset)
- FV(Payment,Rate,Term)
- HLOOKUP(LookupValue,RangeReference,RowNumber)
- HOUR(TimeSerialNumber)
- IF(Condition,ValueIfTrue,ValueIfFalse)
- INDEX(RangeReference,Column,Row)
- INT(x)
- IRR(Guess,RangeReference)
- ISERR(x)
- ISNA(x)
- LEFT(TextValue,Length)
- LENGTH(TextValue)
- LN(x)
- LOG(x)
- LOWER(TextValue)
- MAX(RangeReference0,RangeReference1,...)
- MID(TextValue,Offset,Length)
- MIN(RangeReference0,RangeReference1,...)
- MINUTE(TimeSerialNumber)
- MOD(Numerator,Denominator)
- MONTH(DateSerialNumber)
- N(RangeReference)
- NA()
- NOT(Logical)
- NOW()
- NPV(Rate,RangeReference)
- OR(Logical0,Logical1,...)
- PI()
- PMT(Principal,Rate,Term)
- PROPER(TextValue)
- PV(Payment,Rate,Term)
- RAND()
- RATE(FutureValue,PresentValue,Term)
- REPEAT(TextValue,Count)
- REPLACE(OldText,Offset,Length,NewText)
- RIGHT(TextValue,Length)
- ROUND(x,NumberOfPlaces)
- ROWS(RangeReference)
- S(RangeReference)
- SECOND(TimeSerialNumber)
- SIN(x)
- SLN(Cost,Salvage,Life)
- SQRT(x)
- STD(RangeReference0,RangeReference1,...)
- STRING(x,DecimalPlaces)
- SUM(RangeReference0,RangeReference1,...)
- SYD(Cost,Salvage,Life,Period)
- TAN(x)
- TERM(Payment,Rate,FutureValue)
- TIME(Hour,Minute,Second)
- TRIM(TextValue)
- TRUE()
- UPPER(TextValue)
- VALUE(TextValue)
- VAR(RangeReference0,RangeReference1,...)
- VLOOKUP(LookupValue,RangeReference,ColumnNumber)
- YEAR(DateSerialNumber)
The following list contains the functions and parameters available in Works Database:
- ABS(x)
- ACOS(x)
- ASIN(x)
- ATAN(x)
- ATAN2(x-coordinate,y-coordinate)
- AVG(Field)
- COS(x)
- COUNT(Field)
- CTERM(Rate,FutureValue,PresentValue)
- DATE(Year,Month,Day)
- DAY(DateSerialNumber)
- DDB(Cost,Salvage,Life,Period)
- ERR()
- EXACT(TextValue0,TextValue1)
- EXP(x)
- FIND(FindText,SearchText,Offset)
- FV(Payment,Rate,Term)
- HOUR(TimeSerialNumber)
- INT(x)
- ISERR(x)
- ISNA(x)
- LEFT(TextValue,Length)
- LENGTH(TextValue)
- LN(x)
- LOG(x)
- LOWER(TextValue)
- MAX(Field)
- MID(TextValue,Offset,Length)
- MIN(Field)
- MINUTE(TimeSerialNumber)
- MOD(Numerator,Denominator)
- MONTH(DateSerialNumber)
- NA()
- NOW()
- PI()
- PMT(Principal,Rate,Term)
- PROPER(TextValue)
- PV(Payment,Rate,Term)
- RAND()
- RATE(FutureValue,PresentValue,Term)
- REPEAT(TextValue,Count)
- REPLACE(OldText,Offset,Length,NewText)
- RIGHT(TextValue,Length)
- ROUND(x,NumberOfPlaces)
- SECOND(TimeSerialNumber)
- SIN(x)
- SLN(Cost,Salvage,Life)
- SQRT(x)
- STD(Field)
- STRING(x,DecimalPlaces)
- SUM(Field)
- SYD(Cost,Salvage,Life,Period)
- TAN(x)
- TERM(Payment,Rate,FutureValue)
- TIME(Hour,Minute,Second)
- TRIM(TextValue)
- UPPER(TextValue)
- VALUE(TextValue)
- VAR(Field)
- YEAR(DateSerialNumber)
Additional query words: w_works works2k w2001
Keywords: kbinfo kbui KB242345