Conditional calculations

IF functions for cell ranges In our previous section we’ve primarily dealt with testing conditions inside of a row, i.e. one or more cells in that row, and returning some kind of a result based on conditions in that row. While that is useful when we want to add something new to our rows, we will often have to deal with retrieving data based on criteria from whole ranges of cells, sometimes containing thousands of rows and columns. IF function