Google Sheets - Basic Formulas
(Part of my administrative assistant series on Google Sheets.) These are some of the most basic - and most used functions - in Google Sheets. If you are doing any of these by hand, it is time to begin using formulas to automate the process. NOTE: When it says "selected data" this could be a typed in number OR a referenced cell address; this could also be a combination of both. Basic Operations : + (addition) Adds two selected data. Example: =C2+30 - (subtraction) Subtracts the second data referenced from the first data referenced. Example: =100-D5 * (multiplication) Multiples the two selected data. Example: =C2*D2 / (division) Divides the first referenced data by the second. Example: =E3/2 Order of Operations If the formula is a longer string, standard order of operations is ALWAYS followed: parenthesis/brackets calculated first powers calculated next multiplication/division calculated next addition/subtraction calculated last ...