KB137077 - Works: Works for Windows Spreadsheet and Database Functions

SUMMARY

This article contains a list of functions you can use in Microsoft Works for Windows. For more information on these functions, refer to Appendix A in your Microsoft Works User's Guide or Online Help.

All of these functions can be used in both the Spreadsheet and Database modules, except for HLOOKUP and VLOOKUP, which cannot be used in the Database.

Works for Windows 3.0 and later have additional functions for text. These text fuctions are listed last.

ABS(x)
ACOS(x)
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(DateNumber)
DDB(Cost,Salvage,Life,Period)
ERR()
EXP(x)
FALSE()
FV(Payment,Rate,Term)
HLOOKUP(LookupValue,RangeReference,RowNumber)
HOUR(TimeNumber)
IF(Condition,ValueIfTrue,ValueIfFalse)
INDEX(RangeReference,Column,Row)
INT(x)
IRR(Guess,RangeReference)
ISERR(x)
ISNA(x)
LN(x)
LOG(x)
MAX(RangeReference0,RangeReference1,...)
MIN(RangeReference0,RangeReference1,...)
MINUTE(TimeNumber)
MOD(Numerator,Denominator)
MONTH(DateNumber)
NA()
NOW()
NPV(Rate,RangeReference)
PI()
PMT(Principal,Rate,Term)
PV(Payment,Rate,Term)
RAND()
RATE(FutureValue,PresentValue,Term)
ROUND(x,NumberOfPlaces)
ROWS(RangeReference)
SECOND(TimeNumber)
SIN(x)
SLN(Cost,Salvage,Life)
SQRT(x)
STD(RangeReference0,RangeReference1,...)
SUM(RangeReference0,RangeReference1,..)
SYD(Cost,Salvage,Life,Period)
TAN(x)
TERM(Payment,Rate,FutureValue)
TIME(Hour,Minute,Second)
TRUE()
VAR(RangeReference0,RangeReference1,..)
VLOOKUP(LookupValue,RangeReference,ColumnNumber)
YEAR(DateNumber)

Text Functions in Works for Windows 3.0 and Later

EXACT(TextValue0,TextValue1)
FIND(FindText,SearchText,Offset)
LEFT(TextValue,Length)
LOWER(TextValue)
MID(TextValue,Offset,Length)
N(RangeReference)
PROPER(TextValue)
REPEAT(TextValue,Count)
REPLACE(OldText,Offset,Length,NewText)
RIGHT(TextValue,Length)
S(RangeReference)
STRING(x,DecimalPlaces)
TRIM(TextValue)
UPPER(TextValue)
VALUE(TextValue)