![]() There are times when we want to know how many times a value appears in our spreadsheets. For example, =IF(D2="Gryffindor","10","0") would award 10 points to cell D2 if that cell contained the word "Gryffindor." This allows you to enter a text value into the cell "if" something else in your spreadsheet is true or false. The IF formula in Excel is denoted =IF(logical_test, value_if_true, value_if_false). See how this might look in an Excel spreadsheet for a content marketer, below: Note the colon between both cells, rather than a comma. ![]() To find the SUM of the values in cells B2 through B11, type the following formula into a cell of your spreadsheet: =SUM(B2:B11). Keep in mind you can also find the total value of a list of numbers in Excel. If there are no numbers in either cell, the formula will return 0. Press "Enter," and the cell will produce the total of the numbers currently filled in cells B2 and B11.
0 Comments
Leave a Reply. |