Article ID: 81751 - Last Review: November 16, 2006 - Revision: 3.1 Works: Valid Database FunctionsThis article was previously published under Q81751 SUMMARY
The following is a list of functions that you can use in the Works Database:
ABS(x) ACOS(x) ASIN(x) ATAN(x) ATAN2(x-coordinate,y-coordinate) AVG(Fieldname0,Fieldname1,...) CHOOSE(Choice,Option0,Option1,...) COS(x) COUNT(Fieldname1,Fieldname2,...) CTERM(Rate,FutureValue,PresentValue) DATE(Year,Month,Day) DAY(DateNumber) DDB(Cost,Salvage,Life,Period) ERR() EXP(x) FALSE() FV(Payment,Rate,Term) HOUR(TimeNumber) IF(Condition,ValueIfTrue,ValueIfFalse) INT(x) ISERR(x) ISNA(x) LN(x) LOG(x) MAX(Fieldname1,Fieldname2,...) MIN(Fieldname1,Fieldname2,...) MINUTE(TimeNumber) MOD(Numerator,Denominator) MONTH(DateNumber) NA() NOW() PI() PMT(Principal,Rate,Term) PV(Payment,Rate,Term) RAND() RATE(FutureValue,PresentValue,Term) ROUND(x,NumberOfPlaces) SECOND(TimeNumber) SIN(x) SLN(Cost,Salvage,Life) SQRT(x) SUM(Fieldname1,Fieldname2,..) SYD(Cost,Salvage,Life,Period) TAN(x) TERM(Payment,Rate,FutureValue) TIME(Hour,Minute,Second) TRUE() YEAR(DateNumber) AND(logical1,logical2,...) EXACT(Textvalue1,Textvalue2) FIND(FindText,SearchText,Offset) LEFT(TextValue,Length) LENGTH(TextValue) LOWER(TextValue) MID(TextValue,Offset,Length) N(RangeReference) NOT(logical) OR(logical1,logical2,...) PROPER(TextValue) REPEAT(TextValue,Count) REPLACE(OldText,Offset,Length,NewText) RIGHT(TextValue,Length) S(RangeReference) STRING(x,DecimalPlaces) TRIM(TextValue) UPPER(TextValue) VALUE(TextValue) APPLIES TO
| Article Translations
|

Back to the top
