The main distinction between the two is that a formula is a custom expression created by the user, whereas a function is a pre-written calculation built into Excel that you can use in formulas.

Playing with user-defined functions But there’s much more: They increase functionality with less effort. Written by Martin W.P. Reid, Contributor and Susan Harkins, Contributor June 23, 2002 at ...