Function and formula. A formula is defined as a statement written by any user, whether simple or sophisticated, whereas a function is a pre-specified sort of formula. Functions, on the other hand, are predefined formulas that are already present in the sheet.