For example, A1:A10 is cells A1 through A10. Using the colon (:) lets you get a range of cells for a formula.Math functions or calculations can use an operator, including plus (+), minus (-), multiply (*), divide (/), greater than (>), and less than (<). If a math function is being performed, like addition, subtraction, and multiplication, the math formula is surrounded in parentheses.The function tells the spreadsheet the type of formula. After the equal symbol, either a cell or formula function is entered.All spreadsheet formulas begin with an equal sign (=) symbol.For example, you could have a total cell that adds all values in a column. By creating formulas, you can perform quick calculations even if the information changes in the cells relating to the formula. Formulas are what helped make spreadsheets so popular.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |