The on-line FormulaForge Math View enables users to submit an Excel formula and then see it as it would appear in a mathematics text. As shown below, the on-line Math View displays the familiar quadratic formula using the familiar mathematical notations for fractions, squares, and square roots, thereby making the formula much easier to read and understand.
(-B3 + SQRT(B3^2-4*A3*C3))/(2*A3) |
|
Quadratic formula in Excel notation | Quadratic formula in mathematical notation |
---|
Math View employs the following typesetting conventions. Here, x
, y
, and z
represent arbitrary expressions that are typeset as x, y, and z.
Expression | Representation | |
---|---|---|
Product: x*y |
||
Simple fraction: x/y , (x)/y , x/(y) , (x)/(y) |
||
Fraction with fraction in numerator: x/y/z |
||
Simple power: x^y |
||
Power of a power: x^y^z |
||
Less than or equal to: x<=y |
||
Not equal to: x<>y |
||
Greater than or equal to: x>=y |
||
Range union: x, y |
||
Range intersection: x y |
||
ABS(x) |
||
EXP(x) |
||
INT(x) |
||
LOG10(x) |
||
PI() |
||
SQRT(x) |
See Limitations for a brief list of the current limitations of Math View.