Works: Spreadsheet and Database Functions (242345)


The information in this article applies to:

  • Microsoft Works 2000
  • Microsoft Works 6
  • 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)
Modification Type:MajorLast Reviewed:6/29/2004
Keywords:kbinfo kbui KB242345
©2004 Microsoft Corporation. All rights reserved.