excel-formula Introduction


Example

Excel formulas are used to process simple or complex equations and output the result to a specific cell within a worksheet.


(There is an exception to this where the WorksheetFunction class is used in VBA programming, however VBA is out of scope for this tag - please refer to the excel-vba or vba documentation for VBA related articles.)


Formulas can be used to convert, manipulate or evaluate many different kinds of expressions using all different kinds of data. There are however some restrictions around formulas and what they are able to achieve.

  • Formulas cannot change any part of a worksheet or contents of another cell.
  • Formulas can only return numbers precise up to 15 digits.
  • Formulas cannot contain more than 8,192 characters.
  • Formulas cannot reference more than 2,048 other ranges.
  • Formulas cannot use more than 255 arguments in any given function.
  • Dates used in calculations must be in the range of 1900-01-01 to 9999-12-31