Works: Spreadsheet and Database Functions

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.

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)