PC World Komputer 1997 November/Pcwk1197.iso/LOTUS/Eng-ins/123/SSFN60EN.CNT

Microsoft Windows Help File Content | 1996-09-07 | 14KB | 321 lines

:Base SSFN60EN.HLP>Steps
:Title 1-2-3 @Functions Help
:Link SS1N60EN.HLP
2 Alphabetical List of @Functions
3 @Functions A-Z=[e-mail]>Overview
2 @Functions by Category
3 Calendar
4 Date Calculations
5 @D360 =[e-mail]>OVERVIEW
5 @DATE =[e-mail]>OVERVIEW
5 @DATECONVERT=[e-mail]>OVERVIEW
5 @DATEDIF =[e-mail]>OVERVIEW
5 @DATEINFO =[e-mail]>OVERVIEW
5 @DATESTRING=[e-mail]>OVERVIEW
5 @DATEVALUE =[e-mail]>OVERVIEW
5 @DAY =[e-mail]>OVERVIEW
5 @DAYS =[e-mail]>OVERVIEW
5 @DAYS360 =[e-mail]>OVERVIEW
5 @MONTH =[e-mail]>OVERVIEW
5 @NETWORKDAYS=[e-mail]>OVERVIEW
5 @NEXTMONTH=[e-mail]>OVERVIEW
5 @TDATESTRING=[e-mail]>OVERVIEW
5 @TDOW=[e-mail]>OVERVIEW
5 @TLDATESTRING=[e-mail]>OVERVIEW
5 @WEEKDAY =[e-mail]>OVERVIEW
5 @WORKDAY =[e-mail]>OVERVIEW
5 @YEAR =[e-mail]>OVERVIEW
4 Time Calculations
5 @HOUR =[e-mail]>OVERVIEW
5 @MINUTE =[e-mail]>OVERVIEW
5 @SECOND =[e-mail]>OVERVIEW
5 @TIME =[e-mail]>OVERVIEW
5 @TIMEVALUE =[e-mail]>OVERVIEW
4 Current Date and Time Calculations
5 @NOW =[e-mail]>OVERVIEW
5 @TODAY =[e-mail]>OVERVIEW
3 Database
4 @DAVG =[e-mail]>OVERVIEW
4 @DCOUNT =[e-mail]>OVERVIEW
4 @DGET =[e-mail]>OVERVIEW
4 @DMAX =[e-mail]>OVERVIEW
4 @DMIN =[e-mail]>OVERVIEW
4 @DPURECOUNT =[e-mail]>OVERVIEW
4 @DSTD =[e-mail]>OVERVIEW
4 @DSTDS =[e-mail]>OVERVIEW
4 @DSUM =[e-mail]>OVERVIEW
4 @DVAR =[e-mail]>OVERVIEW
4 @DVARS =[e-mail]>OVERVIEW
3 Engineering
4 @BESSELI =[e-mail]>OVERVIEW
4 @BESSELJ =[e-mail]>OVERVIEW
4 @BESSELK =[e-mail]>OVERVIEW
4 @BESSELY =[e-mail]>OVERVIEW
4 @BETA =[e-mail]>OVERVIEW
4 @BETAI =[e-mail]>OVERVIEW
4 @DECIMAL =[e-mail]>OVERVIEW
4 @ERF =[e-mail]>OVERVIEW
4 @ERFC =[e-mail]>OVERVIEW
4 @ERFD =[e-mail]>OVERVIEW
4 @GAMMA =[e-mail]>OVERVIEW
4 @GAMMAI =[e-mail]>OVERVIEW
4 @GAMMALN =[e-mail]>OVERVIEW
4 @HEX =[e-mail]>OVERVIEW
4 @SERIESSUM =[e-mail]>OVERVIEW
4 @SQRTPI =[e-mail]>OVERVIEW
3 Financial
4 Annuities
5 @FV =[e-mail]>OVERVIEW
5 @FV2=[e-mail]>OVERVIEW
5 @FVAL =[e-mail]>OVERVIEW
5 @FVAMOUNT=[e-mail]>OVERVIEW
5 @IPAYMT =[e-mail]>OVERVIEW
5 @IRATE =[e-mail]>OVERVIEW
5 @NPER =[e-mail]>OVERVIEW
5 @PAYMT =[e-mail]>OVERVIEW
5 @PMT =[e-mail]>OVERVIEW
5 @PMT2=[e-mail]>OVERVIEW
5 @PMTC =[e-mail]>OVERVIEW
5 @PMTI=H_FUNC_PMTI @SSFN60EN.HLP>OVERVIEW
5 @PPAYMT =[e-mail]>OVERVIEW
5 @PV =[e-mail]>OVERVIEW
5 @PV2=[e-mail]>OVERVIEW
5 @PVAL =[e-mail]>OVERVIEW
5 @PVAMOUNT=[e-mail]>OVERVIEW
5 @SPI=[e-mail]>OVERVIEW
5 @TERM =[e-mail]>OVERVIEW
5 @TERM2=[e-mail]>OVERVIEW
4 Bonds
5 @ACCRUED =[e-mail]>OVERVIEW
5 @ACCRUED2 =[e-mail]>OVERVIEW
5 @DURATION=[e-mail]>OVERVIEW
5 @MDURATION=[e-mail]>OVERVIEW
5 @PRICE =[e-mail]>OVERVIEW
5 @PRICE2 =[e-mail]>OVERVIEW
5 @YIELD =[e-mail]>OVERVIEW
5 @YIELD2=[e-mail]>OVERVIEW
4 Capital-Budgeting Tools
5 @IRR =[e-mail]>OVERVIEW
5 @MIRR =[e-mail]>OVERVIEW
5 @NPV =[e-mail]>OVERVIEW
5 @XIRR=[e-mail]>OVERVIEW
5 @XNPV=[e-mail]>OVERVIEW
4 Depreciation
5 @DB =[e-mail]>OVERVIEW
5 @DDB =[e-mail]>OVERVIEW
5 @SLN =[e-mail]>OVERVIEW
5 @SYD =[e-mail]>OVERVIEW
5 @VDB =[e-mail]>OVERVIEW
4 Single-Sum Compounding
5 @CTERM =[e-mail]>OVERVIEW
5 @RATE =[e-mail]>OVERVIEW
3 Information
4 Cell and Range Information
5 @CELL =[e-mail]>OVERVIEW
5 @CELLPOINTER =[e-mail]>OVERVIEW
5 @COLS =[e-mail]>OVERVIEW
5 @COORD =[e-mail]>OVERVIEW
5 @DATALINK =[e-mail]>OVERVIEW
5 @RANGENAME =[e-mail]>OVERVIEW
5 @REFCONVERT =[e-mail]>OVERVIEW
5 @ROWS =[e-mail]>OVERVIEW
5 @SHEETS =[e-mail]>OVERVIEW
4 System and Session Information
5 @INFO =[e-mail]>OVERVIEW
5 @SCENARIOINFO =[e-mail]>OVERVIEW
5 @SCENARIOLAST =[e-mail]>OVERVIEW
5 @VERSIONCURRENT =[e-mail]>OVERVIEW
5 @VERSIONDATA =[e-mail]>OVERVIEW
5 @VERSIONINFO =[e-mail]>OVERVIEW
4 Error Checking
5 @ERR =[e-mail]>OVERVIEW
5 @NA =[e-mail]>OVERVIEW
3 Logical
4 @FALSE =[e-mail]>OVERVIEW
4 @IF =[e-mail]>OVERVIEW
4 @ISAAF =[e-mail]>OVERVIEW
4 @ISAAP =[e-mail]>OVERVIEW
4 @ISBETWEEN=[e-mail]>OVERVIEW
4 @ISEMPTY=[e-mail]>OVERVIEW
4 @ISERR =[e-mail]>OVERVIEW
4 @ISFILE =[e-mail]>OVERVIEW
4 @ISMACRO =[e-mail]>OVERVIEW
4 @ISNA =[e-mail]>OVERVIEW
4 @ISNUMBER =[e-mail]>OVERVIEW
4 @ISRANGE =[e-mail]>OVERVIEW
4 @ISSTRING =[e-mail]>OVERVIEW
4 @TRUE =[e-mail]>OVERVIEW
3 Lookup
4 @@ =[e-mail]>OVERVIEW
4 @CHOOSE =[e-mail]>OVERVIEW
4 @HLOOKUP =[e-mail]>OVERVIEW
4 @INDEX =[e-mail]>OVERVIEW
4 @MATCH =[e-mail]>OVERVIEW
4 @MAXLOOKUP=[e-mail]>OVERVIEW
4 @MINLOOKUP=[e-mail]>OVERVIEW
4 @VLOOKUP =[e-mail]>OVERVIEW
4 @XINDEX =[e-mail]>OVERVIEW
3 Mathematical
4 General
5 @ABS =[e-mail]>OVERVIEW
5 @EXP =[e-mail]>OVERVIEW
5 @EXP2 =[e-mail]>OVERVIEW
5 @FACT =[e-mail]>OVERVIEW
5 @FACTLN =[e-mail]>OVERVIEW
5 @INT =[e-mail]>OVERVIEW
5 @LARGE =[e-mail]>OVERVIEW
5 @LN =[e-mail]>OVERVIEW
5 @LOG =[e-mail]>OVERVIEW
5 @MOD =[e-mail]>OVERVIEW
5 @MODULO=[e-mail]>OVERVIEW
5 @QUOTIENT =[e-mail]>OVERVIEW
5 @RAND =[e-mail]>OVERVIEW
5 @SIGN =[e-mail]>OVERVIEW
5 @SMALL =[e-mail]>OVERVIEW
5 @SQRT =[e-mail]>OVERVIEW
4 Conversion
5 @DEGTORAD =[e-mail]>OVERVIEW
5 @RADTODEG =[e-mail]>OVERVIEW
4 Hyperbolic
5 @ACOSH =[e-mail]>OVERVIEW
5 @ACOTH =[e-mail]>OVERVIEW
5 @ACSCH =[e-mail]>OVERVIEW
5 @ASECH =[e-mail]>OVERVIEW
5 @ASINH =[e-mail]>OVERVIEW
5 @ATANH =[e-mail]>OVERVIEW
5 @COSH =[e-mail]>OVERVIEW
5 @COTH =[e-mail]>OVERVIEW
5 @CSCH =[e-mail]>OVERVIEW
5 @SECH =[e-mail]>OVERVIEW
5 @SINH =[e-mail]>OVERVIEW
5 @TANH =[e-mail]>OVERVIEW
4 Rounding Values
5 @EVEN =[e-mail]>OVERVIEW
5 @ODD =[e-mail]>OVERVIEW
5 @ROUND =[e-mail]>OVERVIEW
5 @ROUNDDOWN =[e-mail]>OVERVIEW
5 @ROUNDM =[e-mail]>OVERVIEW
5 @ROUNDUP =[e-mail]>OVERVIEW
5 @TRUNC =[e-mail]>OVERVIEW
4 Trigonometric
5 @ACOS =[e-mail]>OVERVIEW
5 @ACOT =[e-mail]>OVERVIEW
5 @ACSC =[e-mail]>OVERVIEW
5 @ASEC =[e-mail]>OVERVIEW
5 @ASIN =[e-mail]>OVERVIEW
5 @ATAN =[e-mail]>OVERVIEW
5 @ATAN2 =[e-mail]>OVERVIEW
5 @COS =[e-mail]>OVERVIEW
5 @COT =[e-mail]>OVERVIEW
5 @CSC =[e-mail]>OVERVIEW
5 @PI =[e-mail]>OVERVIEW
5 @SEC =[e-mail]>OVERVIEW
5 @SIN =[e-mail]>OVERVIEW
5 @TAN =[e-mail]>OVERVIEW
3 Statistical
4 General
5 @AVEDEV =[e-mail]>OVERVIEW
5 @AVG =[e-mail]>OVERVIEW
5 @CORREL =[e-mail]>OVERVIEW
5 @COUNT =[e-mail]>OVERVIEW
5 @COV =[e-mail]>OVERVIEW
5 @DEVSQ =[e-mail]>OVERVIEW
5 @GEOMEAN =[e-mail]>OVERVIEW
5 @GRANDTOTAL =[e-mail]>OVERVIEW
5 @HARMEAN =[e-mail]>OVERVIEW
5 @KURTOSIS =[e-mail]>OVERVIEW
5 @MAX =[e-mail]>OVERVIEW
5 @MEDIAN =[e-mail]>OVERVIEW
5 @MIN =[e-mail]>OVERVIEW
5 @NSUM=[e-mail]>OVERVIEW
5 @PRODUCT =[e-mail]>OVERVIEW
5 @PUREAVG =[e-mail]>OVERVIEW
5 @PURECOUNT =[e-mail]>OVERVIEW
5 @PUREMAX =[e-mail]>OVERVIEW
5 @PUREMEDIAN=[e-mail]>OVERVIEW
5 @PUREMIN =[e-mail]>OVERVIEW
5 @PURESTD =[e-mail]>OVERVIEW
5 @PURESTDS =[e-mail]>OVERVIEW
5 @PUREVAR =[e-mail]>OVERVIEW
5 @PUREVARS =[e-mail]>OVERVIEW
5 @SEMEAN =[e-mail]>OVERVIEW
5 @SKEWNESS =[e-mail]>OVERVIEW
5 @STD =[e-mail]>OVERVIEW
5 @STDS =[e-mail]>OVERVIEW
5 @SUBTOTAL =[e-mail]>OVERVIEW
5 @SUM =[e-mail]>OVERVIEW
5 @SUMNEGATIVE=[e-mail]>OVERVIEW
5 @SUMPOSITIVE=[e-mail]>OVERVIEW
5 @SUMPRODUCT =[e-mail]>OVERVIEW
5 @SUMSQ =[e-mail]>OVERVIEW
5 @SUMXMY2 =[e-mail]>OVERVIEW
5 @VAR =[e-mail]>OVERVIEW
5 @VARS =[e-mail]>OVERVIEW
5 @WEIGHTAVG =[e-mail]>OVERVIEW
4 Forecasting
5 @FORECAST=[e-mail]>OVERVIEW
5 @REGRESSION =[e-mail]>OVERVIEW
4 Probability
5 @BINOMIAL =[e-mail]>OVERVIEW
5 @CHIDIST =[e-mail]>OVERVIEW
5 @COMBIN =[e-mail]>OVERVIEW
5 @CRITBINOMIAL =[e-mail]>OVERVIEW
5 @FDIST =[e-mail]>OVERVIEW
5 @NORMAL =[e-mail]>OVERVIEW
5 @PERMUT =[e-mail]>OVERVIEW
5 @POISSON =[e-mail]>OVERVIEW
5 @TDIST =[e-mail]>OVERVIEW
4 Ranking
5 @DECILE=[e-mail]>OVERVIEW
5 @PERCENTILE =[e-mail]>OVERVIEW
5 @PRANK =[e-mail]>OVERVIEW
5 @QUARTILE=[e-mail]>OVERVIEW
5 @RANK =[e-mail]>OVERVIEW
4 Significance Tests
5 @CHITEST =[e-mail]>OVERVIEW
5 @FTEST =[e-mail]>OVERVIEW
5 @TTEST =[e-mail]>OVERVIEW
5 @ZTEST =[e-mail]>OVERVIEW
3 Text
4 General
5 @CHAR =[e-mail]>OVERVIEW
5 @CLEAN =[e-mail]>OVERVIEW
5 @CODE =[e-mail]>OVERVIEW
5 @EXACT =[e-mail]>OVERVIEW
5 @FIND =[e-mail]>OVERVIEW
5 @FULLP=[e-mail]>OVERVIEW
5 @HALFP=[e-mail]>OVERVIEW
5 @LEFT =[e-mail]>OVERVIEW
5 @LENGTH =[e-mail]>OVERVIEW
5 @LOWER =[e-mail]>OVERVIEW
5 @MID =[e-mail]>OVERVIEW
5 @N =[e-mail]>OVERVIEW
5 @NUMBERSTRING=[e-mail]>OVERVIEW
5 @PROPER =[e-mail]>OVERVIEW
5 @REPEAT =[e-mail]>OVERVIEW
5 @REPLACE =[e-mail]>OVERVIEW
5 @RIGHT =[e-mail]>OVERVIEW
5 @S =[e-mail]>OVERVIEW
5 @SETSTRING=[e-mail]>OVERVIEW
5 @STRING =[e-mail]>OVERVIEW
5 @TRIM =[e-mail]>OVERVIEW
5 @UPPER =[e-mail]>OVERVIEW
5 @VALUE =[e-mail]>OVERVIEW
4 Bi-Directional Language Functions
5 @FINDB=[e-mail]>OVERVIEW
5 @LEFTB=[e-mail]>OVERVIEW
5 @LENGTHB=[e-mail]>OVERVIEW
5 @MIDB=[e-mail]>OVERVIEW
5 @REPLACEB=[e-mail]>OVERVIEW
5 @RIGHTB=[e-mail]>OVERVIEW
4 Thai Language Functions
5 @EDIGIT=[e-mail]>OVERVIEW
5 @TDIGIT=[e-mail]>OVERVIEW
5 @TFIND=[e-mail]>OVERVIEW
5 @TLEFT=[e-mail]>OVERVIEW
5 @TLENGTH=[e-mail]>OVERVIEW
5 @TMID=[e-mail]>OVERVIEW
5 @TNUMBERSTRING=[e-mail]>OVERVIEW
5 @TREPLACE=[e-mail]>OVERVIEW
5 @TRIGHT=[e-mail]>OVERVIEW