Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

Functions in Formulas

  • Undo

    Undo
    po
  • Clipboard

    Clipboard
    po
  • v
    v
    popopopo
    Font

    Font
    po
  • Alignment

    Alignment
    po
  • po
    dialogboxlauncherNumber

    Number
    po
  • Cells

    Cells
    po
  • Editing

    Editing
    po
  • Styles

    Styles
    po
  • dialogboxlauncherPage Setup

    Page Setuppo
  • dialogboxlauncherPrint

    Print
    po
  • Document Views

    Document Viewspo
  • Show

    Show
    po
  • View

    View
    po
  • Window

    Window
    po
  • Table Name
    Properties

    Properties
    po
  • Tools

    Tools
    po
  • Table Style Options

    Table Style Optionspo
  • Table Style Options

    Table Style Optionspo
  • Layout

    Layout
    po
  • PivotTable Style Options

    PivotTable Style Optionspo
 


This example demonstrates how to programmatically use predefined functions in formulas to perform simple or complex calculations over arguments. Set the Range.Formula property to a formula. Follow the rules below to create a formula that uses a function.

  • Start the formula with the "=" sign, as you usually do when creating formulas.
  • Specify the function name.
  • Specify the function arguments in parentheses. Arguments can be numbers, text and logical values, cell references and names, or other functions.