Works: Works for Windows Spreadsheet and Database Functions (137077)
The information in this article applies to:
- Microsoft Works 6
- Microsoft Works 2000
- Microsoft Works 2.0
- Microsoft Works 3.0
- Microsoft Works 4.0
- Microsoft Works 4.5
This article was previously published under Q137077 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)
| Modification Type: | Major | Last Reviewed: | 11/24/2003 |
|---|
| Keywords: | kbinfo kbref kbui KB137077 |
|---|
|