Microsoft KB Archive/242345

= Works: Spreadsheet and Database Functions =

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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.