On-Line Math View Help

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.

Quadratic formula in Excel notation	Quadratic formula in mathematical notation
`(-B3 + SQRT(B3^2-4A3C3))/(2*A3)`	$\frac{- B_{3} + \sqrt{B_{3}^{2} - 4 \cdot A_{3} \cdot C_{3}}}{2 \cdot A_{3}}$

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`		$x \cdot y$
Simple fraction: `x/y`, `(x)/y`, `x/(y)`, `(x)/(y)`		$\frac{x}{y}$
Fraction with fraction in numerator: `x/y/z`		$\frac{x}{y \cdot z}$
Simple power: `x^y`		$x^{y}$
Power of a power: `x^y^z`		$x^{y \cdot z}$
Less than or equal to: `x<=y`		$x \leq y$
Not equal to: `x<>y`		$x \neq y$
Greater than or equal to: `x>=y`		$x \geq y$
Range union: `x, y`		$x \cup y$
Range intersection: `x y`		$x \cap y$
`ABS(x)`		$\| x \|$
`EXP(x)`		$e^{x}$
`INT(x)`		$⌊ x ⌋$
`LOG10(x)`		${log}_{10} (x)$
`PI()`		$π$
`SQRT(x)`		$\sqrt{x}$

See Limitations for a brief list of the current limitations of Math View.

FormulaForge

Spreadsheet Formula Analysis

On-Line Math View Help

Typesetting technology