Microsoft KB Archive/137077

= Works: Works for Windows Spreadsheet and Database Functions =

Article ID: 137077

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Works 6.0
 * Microsoft Works 2000 Standard Edition
 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.5 Standard Edition

-



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)

Additional query words: 2.00 3.00 4.00 4.00a 4.50 w_works works2k works6

Keywords: kbinfo kbref kbui KB137077

-

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

© Microsoft Corporation. All rights reserved.