.HEAD 0 + 1-2-3 Functions Template .HEAD 1 + Database statistical functions .HEAD 2 + Average of values in list .HEAD 3 - @DAVG( input, offset, criterion ) .HEAD 2 + Count of items in list .HEAD 3 - @DCOUNT( input, offset, criterion ) .HEAD 2 + Maximum of values in list .HEAD 3 - @DMAX( input, offset, criterion ) .HEAD 2 + Minimum of values in list .HEAD 3 - @DMIN( input, offset, criterion ) .HEAD 2 + Standard deviation of values in list .HEAD 3 - @DSTD( input, offset, criterion ) .HEAD 2 + Sum of values in list .HEAD 3 - @DSUM( input, offset, criterion ) .HEAD 2 + Variance of values in list .HEAD 3 - @DVAR( input, offset, criterion ) .HEAD 1 + Date functions .HEAD 2 + Date .HEAD 3 - @DATE( year, month, day ) .HEAD 2 + Day number .HEAD 3 - @DAY( date ) .HEAD 2 + Month number .HEAD 3 - @MONTH( date ) .HEAD 2 + Year number .HEAD 3 - @YEAR( date ) .HEAD 2 + DOS system date .HEAD 3 - @TODAY .HEAD 1 + Financial functions .HEAD 2 + Future value .HEAD 3 - @FV( pmt, int, term ) .HEAD 2 + Internal rate of return .HEAD 3 - @IRR( guess, range ) .HEAD 2 + Net present value .HEAD 3 - @NPV( x, range ) .HEAD 2 + Payment .HEAD 3 - @PMT( prn, int, term ) .HEAD 2 + Present value .HEAD 3 - @PV( pmt, int, term ) .HEAD 1 + Logical functions .HEAD 2 + False, value of 0 .HEAD 3 - @FALSE .HEAD 2 + True, value of 1 .HEAD 3 - @TRUE .HEAD 2 + Value of 1 if Not Available .HEAD 3 - @ISNA( x ) .HEAD 2 + Value of 1 if Error .HEAD 3 - @ISERR( x ) .HEAD 2 + If Condition is False, then x, else y .HEAD 3 - @IF( condition, x, y ) .HEAD 1 + Mathematical functions .HEAD 2 + Absolute value .HEAD 3 - @ABS( x ) .HEAD 2 + Exponent .HEAD 3 - @EXP( x ) .HEAD 2 + Integer .HEAD 3 - @INT( x ) .HEAD 2 + Log base 10 .HEAD 3 - @LOG( x ) .HEAD 2 + Log base e .HEAD 3 - @LN( x ) .HEAD 2 + Pi .HEAD 3 - @PI .HEAD 2 + Random number between 0 and 1 .HEAD 3 - @RAND .HEAD 2 + Round x to d decimal places .HEAD 3 - @ROUND( x, d ) .HEAD 2 + X Mod y .HEAD 3 - @MOD( x, y ) .HEAD 1 + Special functions .HEAD 2 + Not Available .HEAD 3 - @NA .HEAD 2 + Error .HEAD 3 - @ERR .HEAD 2 + Indexed lookup .HEAD 3 - @CHOOSE( index, x1, x2, ... ) .HEAD 2 + Horizontal table lookup .HEAD 3 - @HLOOKUP( x, range ) .HEAD 2 + Vertical table lookup .HEAD 3 - @VLOOKUP( x, range ) .HEAD 1 + Statistical functions .HEAD 2 + Average of values in list .HEAD 3 - @AVG( list ) .HEAD 2 + Count of items in list .HEAD 3 - @COUNT( list ) .HEAD 2 + Maximum of values in list .HEAD 3 - @MAX( list ) .HEAD 2 + Minimum of values in list .HEAD 3 - @MIN( list ) .HEAD 2 + Standard deviation of values in list .HEAD 3 - @STD( list ) .HEAD 2 + Sum of values in list .HEAD 3 - @SUM( list ) .HEAD 2 + Variance of values in list .HEAD 3 - @VAR( list ) .HEAD 1 + Trigonometric functions .HEAD 2 + Cosine .HEAD 3 - @COS( x ) .HEAD 2 + Sine .HEAD 3 - @SIN( x ) .HEAD 2 + Tangent .HEAD 3 - @TAN( x ) .HEAD 2 + Arc cosine .HEAD 3 - @ACOS( x ) .HEAD 2 + Arc sine .HEAD 3 - @ASIN( x ) .HEAD 2 + 2-quadrant arc tangent .HEAD 3 - @ATAN( x ) .HEAD 2 + 4-qaudrant arc tangent .HEAD 3 - @ATAN2( x, y ) .HEAD 1 - User-defined Macros um of values in list .HEAD 3 - @SUM( list ) .HEAD 2 + Variance of values in list .HEAD 3 - @VAR( list ) .HEAD 1 + Trigonometric functions .HEAD 2 + Cosine .HEAD 3 - @COS( x ) .HEAD 2 + Sine .HEAD 3 - @SIN( x ) .HEAD 2 + Tangent .HEAD 3 - @TAN( x ) .HEAD 2 + Arc cosine .HEAD 3 - @ACOS