The system used for addition, subtraction, multiplication, division fixing of percentage etc on the basis of digits included in worksheet is called Formula. By using formula different acute Accounts works are done.

Such as we are to add digits kept in cell A_{1} and A_{2} then typing = A_{1} + A_{2} and pressing Enter the addition of the digits of the two cells will be available. Here = A_{1} + A_{2} is the formulas.

Function: The earlier preserved formula is the spreadsheet software for mathematical works is called Function. Each function has a short shop. Function is the short shop of formula where different Mathematical formulas are preserved earlier. That the process of using formulas in short shapes is called function, such as: To add A_{1}, A_{2}, A_{3}, A_{4}, A_{5} The formula is A_{1} + A_{2} + A_{3} + A_{4 }+ A_{5} where much time is needed to typist, and there is possibility of error. Using function, the above formula can be written as = SUM (A_{1}: A_{5}) Here SUM is function.