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.