You are working on sales data and need some analysis, so you enter the data as below and make some formulas.

After you enter all your formulas, you realize you had to format all those cells which have a formula, no other cells need to formatted.

Let’s go step-by-step.

1. Create the sheet with formulas.
2. Select the formula cells only, and format them.

## Create the sheet with formulas

• Formula 1 = Multiplies the Price with the Quantity for each order.
• Formula 2 = Sum of all Sales
• Formula 3 = Customer-wise Sales for each customer. =SUMIF has been used for this.
• Formula 4 = Product-wise Sales for each product. =SUMIF has been used for this too.
• Formula 5 = At the current rate at which sales are happening, how much would the total sales be by the end of the year? So if today’s (current) date is 20th October 2015, by the end of the current financial year (date 31st March 2016), the total sales will be \$19,777.
The formula used to derive this is
=365*H4/(TODAY()-IF(MONTH(TODAY())<=3,DATE(YEAR(TODAY())-1,4,1),DATE(YEAR(TODAY()),4,1)))