Render using Cell Values

Renders the selected cell by using the numeric or text values given to the selected cells. If the cell is empty then a zero is used.

(C2^C3)/SQRT(C2^3+C3^2) — Example 1: Style: Excel Buttons:

Appearance

Values derived by variables within an equation are shown in Blue, helping to distinguish these from constant numbers within the equation, which are shown in Black.

Usage

If the Display Assignment () option is enabled, the selected cell will also be included on the left side of the rendered equation.
Otherwise the behaviour is identical to Render using Cell References.

Example 5

Download the example provided and follow the steps below.

Select Cell C5, which contains the formula "=(C2*C3)/SQRT(C2^2+C3^2)".
Click the Render using Cell Value button.

(C2^C3)/SQRT(C2^3+C3^2) — Example 1: Style: Excel Buttons:

The rendered equation is shown to the right of the selected formula, with all the variables replaced with the values shown in the cells referenced by the formula.