Now we are going to solve a short case. We are e-commerce company and want to understand several things: How many orders are lower than the average basket What are the most profitable cities? First of all, let’s fill column D (indicator). We want to use a condition to determine the order value (less or more than the average). Let’s select cell D2 and type necessary condition: IF B2 is more than the average(B:B), then “ok”, if not make it as “bad”. Then, using ‘drag’ method fill formula down.