I have forgotten
my Password

Or login with:

  • Facebookhttp://facebook.com/
  • Googlehttps://www.google.com/accounts/o8/id
  • Yahoohttps://me.yahoo.com



Products » Excel Render »

Worked Examples

This page demonstrates step by step use of fxRender tool to document formulas.

Example 1 - Using Cell References

To reproduce this example, starting with a blank spreadsheet and follow these instructions:

Step Selected Cell Action Input
1 B2 Type: a=
2 B3 Type: b=
3 B5 Type: c=
5 C2 Type: 10
6 C3 Type: 6
7 C5 Type: =SQRT(C2^2+C3^2)
8 C5 Press:

Optional Extra Steps:

9 C5 Press:

to generate:


or:

10 C5 Press:

to generate:

Example 2 - Using Cell Names

To reproduce this example, starting with a blank spreadsheet and follow these instructions:

Step Selected Cell Action Input
1 A1 Type: r_o=
2 A2 Type: r_i=
3 A3 Type: h=
4 A5 Type: V=
5 B1 Type: 20
6 B2 Type: 18
7 B3 Type: 68
8 C1 Type: mm
9 C2 Type: mm
10 C3 Type: mm
11 C5 Type: mm^3
12 B5 Type: =B3*PI( )*(B1-B2)
13 B5 Press:
14 B5 Press:

Optional Extra Steps:

15 B5 Press:

to generate:


or:

16 B5 Press:

to generate:

Example 3 - Using Cell Values

To reproduce this example, starting with a blank spreadsheet and follow these instructions:

Step Selected Cell Action Input
1 A1 Type: s_σ=
2 A2 Type: s_τ=
3 A3 Type: s_γ=
4 A5 Type: s=
5 B1 Type: 1.2
6 B2 Type: 1.3
7 B3 Type: 1.45
8 B5 Type: =(B1*B2)/SQRT(B1^2)+SQRT(B3/5)
9 B5 Press

Optional Extra Steps:

10 B5 Press:

to generate:


or:

11 B5 Press:

to generate: