Microsoft Office Tutorials and References
In Depth Information
Figure 2-2: This formula contains spaces and line breaks.
Formula limits
A formula can consist of up to about 8,000 characters. In the unlikely event that you need to create a formula
that exceeds this limit, you must break the formula up into multiple formulas. You also can opt to create a cus-
tom function by using Visual Basic for Applications (VBA).
Part VI focuses on creating custom functions.
Sample formulas
If you follow the preceding instructions for entering formulas, you can create a variety of formulas. This section
provides a look at some sample formulas.
• The following formula multiplies 150 × .01, returning 1.5. This formula uses only literal values, so it doesn't
seem very useful. However, it may be useful to show your work when you review your spreadsheet later.
=150*.01
• This formula adds the values in cells A1 and A2:
=A1+A2
• The next formula subtracts the value in the cell named Expenses from the value in the cell named Income:
Search JabSto ::




Custom Search