000700 Microsoft Works Functions In Alphabetically Ascending Order

0001.

ACOS(x)

0002.

ASIN(x)

0003.

ATAN(x)

0004.

ATAN2(x-coordinate,y-coordinate)

0005.

AVG(RangeReference0,RangeReference1,...)

0006.

CHOOSE(Choice,Option0,Option1,...)

0007.

COLS(RangeReference)

0008.

COS(x)

0009.

COUNT(RangeReference0,RangeReference1,...)

0010.

CTERM(Rate,FutureValue,PresentValue)

0011.

DATE(Year,Month,Day)

0012.

DAY(DateNumber)

0013.

DDB(Cost,Salvage,Life,Period)

0014.

ERR()

0015.

EXACT(TextValue0,TextValue1)

0016.

EXP(x)

0017.

FALSE()

0018.

FIND(FindText,SearchText,Offset)

0019.

FV(Payment,Rate,Term)

0020.

HLOOKUP(LookupValue,RangeReference,RowNumber)

0021.

HOUR(TimeNumber)

0022.

IF(Condition,ValueIfTrue,ValueIfFalse)

0023.

INDEX(RangeReference,Column,Row)

0024.

INT(x)

0025.

IRR(Guess,RangeReference)

0026.

ISERR(x)

0027.

ISNA(x)

0028.

LEFT(TextValue,Length)

0029.

LENGTH

0030.

LN(x)

0031.

LOG(x)

0032.

LOWER

0033.

LOWER(TextValue)

0034.

MAX(RangeReference0,RangeReference1,...)

0035.

MID(TextValue,Offset,Length)

0036.

MIN(RangeReference0,RangeReference1,...)

0037.

MINUTE(TimeNumber)

0038.

MOD(Numerator,Denominator)

0039.

MONTH(DateNumber)

0040.

N(RangeReference)

0041.

NA()

0042.

NOW()

0043.

NPV(Rate,RangeReference)

0044.

OR(condition 1, condition 2, condition 3,.....)

0045.

PI()

0046.

PMT(Principal,Rate,Term)

0047.

PROPER(TextValue)

0048.

PV(Payment,Rate,Term)

0049.

RAND()

0050.

RATE(FutureValue,PresentValue,Term)

0051.

REPEAT(TextValue,Count)

0052.

REPLACE(OldText,Offset,Length,NewText)

0053.

RIGHT(TextValue,Length)

0054.

ROUND(x,NumberOfPlaces)

0055.

ROWS(RangeReference)

0056.

S(RangeReference)

0057.

SECOND(TimeNumber)

0058.

SIN(x)

0059.

SLN(Cost,Salvage,Life)

0060.

SQRT(x)

0061.

STD(RangeReference0,RangeReference1,...)

0062.

STRING(x,DecimalPlaces)

0063.

SUM(RangeReference0,RangeReference1,..)

0064.

SYD(Cost,Salvage,Life,Period)

0065.

TAN(x)

0066.

TERM(Payment,Rate,FutureValue)

0067.

Text Functions in Works for Windows 3.0 and Later

0068.

TIME(Hour,Minute,Second)

0069.

TRIM(TextValue)

0070.

TRUE()

0071.

UPPER(TextValue)

0072.

VALUE(TextValue) 

0073.

VAR(RangeReference0,RangeReference1,..)

0074.

VLOOKUP(LookupValue,RangeReference,ColumnNumber)

0075.

YEAR(DateNumber) 

#KDXVAWRkXeTK#KDXVAWsZViBK