• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Inserting a Formula

While Calc is certainly no stranger to formulas, there may be a situation where you want to insert a nonworking formula into a sheet for explanatory purposes. For example, you may be doing some calculations involving the speed of light and you would like to place the theoretical formula (using the Greek alphabet) in an object box near the “real” formula that you have placed in the spreadsheet. Inserting formulas as objects makes them the same as graphic images: They are only there to enlighten or add some visual impact to the spreadsheet.

To Insert a Formula

1.
Place the cursor in the location where you want the object to be inserted in your document.

2.
Choose Insert, point at Object, then choose Formula to open the Commands dialog list box (see Figure 11.13).

Figure 11.13. Nonworking formulas can be inserted as objects to help provide visual impact to a spreadsheet.


3.
Begin typing the formula that you want to create.

4.
To insert any special characters into the formula, click the Symbols tool on the Main toolbar. The Symbols dialog box will open (see Figure 11.14).

Figure 11.14. Special symbols can be inserted into a formula using the Symbols dialog box.


5.
Click a symbol in the symbol list and then click Insert. When you have finished inserting symbols, click the Close button.

6.
When you have completed your formula, click anywhere in the spreadsheet.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint