About

Questions about using in-cell functions/formulas in spreadsheet software.

A worksheet function is a function or formula that is used within the spreadsheet of a spreadsheet program like or . The function can be a user-defined function via or a program-ready function like =sum() or =vlookup(). These functions are used to perform simple or complex calculations with the data from the spreadsheet.

Examples of pre-defined functions for Excel 2003 may be found here.

In Excel further functions may be created at will. These are termed User Defined Functions or UDFs.

history | excerpt history