Numbers, constants, variables, and most of the functions may be used
anywhere in an expression, but some functions must be the only term
in the expression. These functions are special because
they do not return a single value, but rather they return a table of
data or textual information, and thus cannot participate in building
a more complex expression.
Expr Use? |
Prototype [ → ResultType ] | |
Expr Use? |
Prototype [ → ResultType ] |
No | AltBase( int, newBase ) | |
No | Normalize( x1, x2, ... ) → mult |
No | Base( int ) | |
No | Normalize2( x1, x2, ... ) → mult |
No | BillSplit( bill, nShares, tipPercent ) → text | |
No | Normalize3( x1, x2, ... ) → mult |
No | Binary( int ) | |
No | Octal( int ) |
No | Calories( activity, weight, dist, min, sec ) → text | |
No | OhmsLaw( power, voltage, current, resistance ) → text |
No | Capacitance( c1, c2, ... ) → text | |
No | Payoff( principal, rate, years, extra ) → table |
No | Cartesian( dist, angle ) → Pair | |
No | Payoff2( payment, rate, balance, extra ) → table |
No | Colors( value1, value2, ... ) → table | |
No | PayoffBiweekly( principal, rate, years, extra ) → table |
No | ComplexAdd( real1, imag1, real2, imag2 ) → (r, i) | |
No | PayoffBiweekly2( payment, rate, balance, extra ) → table |
No | ComplexDiv( real1, imag1, real2, imag2 ) → (r, i) | |
No | PayoffExtra( principal, rate, years, extra ) → table |
No | ComplexExp( real, imag ) → (r, i) | |
No | PayoffExtra2( payment, rate, balance, extra ) → table |
No | ComplexLn( real, imag ) → (r, i) | |
No | PayoffLump( payment, rate, balance, lumpSum ) → table |
No | ComplexMult( real1, imag1, real2, imag2 ) → (r, i) | |
No | PayoffProfile( principal, rate, years, extra, nYears ) → text |
No | ComplexPower( real, imag, x ) → (r, i) | |
No | PayoffProfile2( payment, rate, balance, extra, nYears ) → text |
No | ComplexPower2( real1, imag1, real2, imag2 ) → (r, i) | |
No | PayoffSurvey( payment, rate, balance ) → table |
No | ComplexRoots( nRoots, real, imag ) → (r,i)s | |
No | PayoffView( principal, rate, years ) → text |
No | ComplexSqrt( real, imag ) → (r, i) | |
No | PayoffView2( payment, rate, balance ) → text |
No | CrossProd( x1, y1, z1, x2, y2, z2 ) → text | |
No | Plane2( A1, B1, C1, D1, A2, B2, C2, D2 ) → text |
No | Cubic( a, b, c, d ) → 3 (r, i)s | |
No | PlaneLine( x1, y1, z1, x2, y2, z2, A, B, C, D ) → text |
No | DayOfWeek( year, month, day ) → text | |
No | PlanePoint( x, y, z, A, B, C, D ) → text |
No | DayOfYear( year, month, day ) → text | |
No | PlanePt3( x1, y1, z1, x2, y2, z2, x3, y3, z3 ) → text |
No | DayOfYear2( year, dayNumb ) → text | |
No | Points( activity, weight, dist, min, sec ) → text |
Expr Use? |
Prototype [ → ResultType ] | |
Expr Use? |
Prototype [ → ResultType ] |
No | DaysAway( nDays, year, month, day ) → text | |
No | Polar( x, y ) → Pair |
No | DaysBetw( year1, month1, day1, year2, month2, day2 ) → text | |
No | PricePer( p1,n1, p2,n2, ... ) → table |
No | DaysSince( holiday ) → text | |
No | Quadratic( a, b, c ) → 2 (r, i)s |
No | DaysTil( holiday ) → text | |
No | Quadrature( a, b, expr ) → text |
No | DotProd( x1, y1, z1, x2, y2, z2 ) → text | |
No | Quartic( a, b, c, d, e ) → 4 (r, i)s |
No | EasterDate( year ) → text | |
No | RacePace( distance, hours, minutes, seconds ) → text |
No | EffectiveRate( nominalRate, nPerYear ) → text | |
No | RaceTime( distance, minutes, seconds ) → text |
No | Factor( int ) → mult | |
No | Ratios( v1,n1, v2,n2, ... ) → table |
No | Fitness( code, gender, age, val1, val2 ) → text | |
No | Refinance( currBalance, currPayment, currRate, newRate, loanCharge, loanLoan, newDuration ) → table |
No | HeartRate( age, restingPulse ) → text | |
No | RegPolygon( nSides, length ) → table |
No | HeatIndex( temp, humidity ) → text | |
No | RegPolygon2( nSides, radius ) → table |
No | HeatIndexMetric( temp, humidity ) → text | |
No | Resistance( r1, r2, ... ) → text |
No | Hex( int ) | |
No | Rgb( value, flag ) → table |
No | Holiday( month ) → table | |
No | RgbCompare( value1, value2, ... ) → table |
No | Integrate( a, b, expr ) → text | |
No | Roman( x ) → text |
No | IraProfile( currValue, addition, rate, years ) → table | |
No | Solver( nEqns, x1, x2, ... ) → mult |
No | Karvonen( age, restingPulse ) → text | |
No | Stats( x1, x2, x3, ... ) → mult |
No | Line( x1, y1, x2, y2 ) → text | |
No | Tip( bill ) → table |
No | Line3D( x1, y1, z1, x2, y2, z2 ) → text | |
No | Unknowns( nEqns, x1, x2, ... ) → mult |
No | MatrixInv( N, x11, x12, ..., xNN ) → table | |
No | WindChill( temp, windSpeed ) → text |
No | MidPt( x1, y1, x2, y2 ) → text | |
No | WindChillMetric( temp, windSpeed ) → text |
No | MidPt3D( x1, y1, z1, x2, y2, z2 ) → text | |
No | Ymxb( x1, y1, x2, y2 ) → text |
No | NominalRate( effectiveRate, nPerYear ) → text | | | |
Expr Use? |
Prototype [ → ResultType ] | |
Expr Use? |
Prototype [ → ResultType ] |