How to write formula in spreadsheets

Simple and regularly used functions include: Like formulas, all functions start with an equals sign (=) followed by the function’s name, eg SUM, MIN, MAX, etc. This feature writes a SUM function for you. Highlight or select the cells you want to add together then click the AutoSum button.

Writing a spreadsheet formula is different from writing an equation in math class. The most notable difference is that Excel formulas start with the equal sign ( =) instead of ending with it. Excel formulas look like =3+2 instead of 3 + 2 = . The equal sign indicates that what follows is part of a formula and not just a word or number ...

Simple formulas always start with an equal sign ( = ), followed by constants that are numeric values and calculation operators such as plus ( + ), minus ( - ), asterisk ( * ), or forward slash ( /) signs. Let's take an example of a simple formula. On the worksheet, click the cell in which you want to enter the formula.

An Excel spreadsheet is helpful for displaying information in an organized way but Excel can be used for so much more. Its powerful calculation ability enables you to enter, manipulate, and analyze numbers. To take advantage of this function, you need to learn about formulas, which are essentially math equations.