Your Excel formulas cheat sheet: 22 tips for calculations and common tasks

Many of us fell in love with Excel as we delved into its deep and sophisticated formula features. Because there are multiple ways to get results, you can decide which method works best for you. For example, there are several ways to enter formulas and calculate numbers in Excel. 

5 ways to enter formulas

1. Manually enter Excel formulas:

Long Lists: =SUM(B4:B13)

Short Lists: =SUM(B4,B5,B6,B7) or =SUM(B4+B5+B6+B7). Or, place your cursor in the first empty cell at the bottom of your list (or any cell, really) and press the + sign, then click B4; press the plus sign again and click B5; and so on to the end; then press Enter. Excel adds up this list you just “pointed to” as =+B4+B5+B6+B7.

To read this article in full, please click here

from PCWorld https://ift.tt/2MC434I