Software Search, Categories and Specials

Mathematical Functions Further Details

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

MATHEMATICAL FUNCTIONS Start

On the top bar, the File option let�s you save the function and any results to disk, or retrieve a previously created file. You can also copy the graph to the clipboard, which you can then paste where you please (Word, Paint, etc.).

NOTE: The graph will also be saved using the name you specify but with the .BMP extension (BITMAP).

Use the Print option to print the results.

Click on SHOW EVALUATOR to display the expression evaluator.

Available Functions

In addition to the functions generally available, this program lets you use 8 additional mathematical functions. These are sinh, cosh, tanh, asinh, acosh, atanh, asin, acos. They return, correspondingly, the hyperbolic sine, cosine, and tangent, inverse hyperbolic sine, cosine, and tangent, inverse trigonometric sine and cosine.

Below is a list of the functions available, including the 8 that have been added.

FUNCTION:

RETURNS

sgn

int

cint

abs

rnd

sqr

log

exp

sin

cos

tan

asin

acos

atn

sinh

cosh

tanh

asinh

acosh

atanh

sign

integer value (fractions are discarded)

integer value (fractions are rounded)

absolute value

random

square root

natural logarithm

exponential

trigonometric sine

trigonometric cosine

trigonometric tangent

inverse trigonometric sine

inverse trigonometric cosine

inverse trigonometric tangent

hyperbolic sine

hyperbolic cosine

hyperbolic tangent

inverse hyperbolic sine

inverse hyperbolic cosine

inverse hyperbolic tangent

Available Operators

The operators are listed below in order of precedence.

Negation (-)
Exponentiation (^)
Multiplication and division (*, /)
Integer division (\)
Modulus arithmetic (mod)
Addition and subtraction (+, -)

Comparison Operators (These all have EQUAL precedence)

Equality (=)
Inequality (<>)
Less than (<)
Greater than (>)
Less than or equal to (<=)
Greater than or equal to (>=)

Logical Operators (In order of precedence)

Negation (not)
Conjunction (and)
Disjunction (or)
Exclusion (xor)
Equivalence (eqv)
Implication (imp)

Notes:

If an expression contains operators from different categories, the Arithmetic Operators are evaluated first, then the Comparison Operators, then the Logical Operators. For each category, the precedence is as listed above.

When operators of equal precedence are found, they are evaluated in order of appearance from left to right.

Parentheses always override Operator Precedence rules. Expressions are evaluated from the inside out, Starting with the innermost set of parentheses. Use parentheses to eliminate any possible ambiguity.

You�ll probably use the Arithmetic Operators more often than the others.

Built-in Constants

The constants pi and e are built-in for your convenience:

pi = 3.14159� = atn(1)*4

e = 2.718281� = exp(1)

MATHEMATICAL FUNCTIONS Start

Functions $15.00 Secure Payment Options

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.

See Also: LINEAR ALGEBRA | Ordinary Differential Equations

Instant Download and Money Back Guarantee on Most Software

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft