Hi everyone
I'm having a bit of a brain fry day today. I want to calculate the day-on-day percentage increase/decrease (column C) of the number of activities as shown in column B. Of course I am hitting an issue when it comes to days where there has been zero % change - this is especially true of weekends, where it is very likely that there will be no activities. This is obviously causing me an issue with the formula I have used because you can't divide by 0. Can anyone help me out with a formula/workaround that will enable me to capture the percentage increase / decrease in activity day on day please? I'm using Excel 365. Many thanks in advance.
I'm having a bit of a brain fry day today. I want to calculate the day-on-day percentage increase/decrease (column C) of the number of activities as shown in column B. Of course I am hitting an issue when it comes to days where there has been zero % change - this is especially true of weekends, where it is very likely that there will be no activities. This is obviously causing me an issue with the formula I have used because you can't divide by 0. Can anyone help me out with a formula/workaround that will enable me to capture the percentage increase / decrease in activity day on day please? I'm using Excel 365. Many thanks in advance.
Operations_MI_Als_team.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
4 | Date | Activities recorded | |||
5 | Unit | Count (actual) | %age change DoD | ||
6 | |||||
7 | Source | Daily MI | |||
8 | 27/10/2020 | 174 | 0 | ||
9 | 28/10/2020 | 197 | 13.2 | ||
10 | 29/10/2020 | 320 | 62.4 | ||
11 | 30/10/2020 | 163 | -49.1 | ||
12 | 31/10/2020 | 0 | -100.0 | ||
13 | 01/11/2020 | 0 | #DIV/0! | ||
14 | 02/11/2020 | 346 | #DIV/0! | ||
15 | 03/11/2020 | 423 | 22.3 | ||
16 | 04/11/2020 | 771 | 82.3 | ||
17 | 05/11/2020 | 413 | -46.4 | ||
18 | 06/11/2020 | 662 | 60.3 | ||
19 | 07/11/2020 | 1 | -99.8 | ||
20 | 08/11/2020 | 0 | -100.0 | ||
All data - CEM (19Oct>31Dec) |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C9:C18,C20 | C9 | =(B9-B8)/B8*100 |