Formula help

[Scrumpywill]

Hello,

Could anyone please help, I have last years sales figures month by month and this years sales figures I would like a formula to compare sales percent increase or decreases per month and add a minus highlighting the percentage decrease

Many Thanks for your help and advice

Cheers

 

[r1998]

Hello YusufAkhtar and welcome to MRExcel forum
my formula in cell f5 is

=((E5-$H$3)*100)/$H$4

and i am getting 100 value in f5

 

[Scrumpywill]

If I have grand total figures last year and this year of the last quarter I want to see the increases & decrease as a percentage of each total - what’s the best formula

Thanks again for your help

 

[r1998]

Hello Scrumpywill
Sorry but I am not able to understand your question without data

 

[Scrumpywill]

is It possible to add a table to show you

 

[r1998]

sure

 

[Scrumpywill]

	Apr-17	May-17	Jun-17	Jul-17	Aug-17	Apr-18	May-18	Jun-18	Jul-18	Aug-18	Grand Total
Show stoppers	833	0	974	785	1,701	736	0	709	0	1,194	6,932
2017-2018	833	0	974	785	1,701	0	0	0	0	0	4,293
2018-2019	0	0	0	0	0	736	0	709	0	1,194	2,638	-39%
Card type	995	827	1,445	1,278	2,225	885	852	720	784	1,109	11,119
2017-2018	995	827	1,445	1,278	2,225	0	0	0	0	0	6,769
2018-2019	0	0	0	0	0	885	852	720	784	1,109	4,350	-36%
weld a type	305	429	402	533	721	1,357	751	654	461	871	6,483
2017-2018	305	429	402	533	721	0	0	0	0	0	2,389
2018-2019	0	0	0	0	0	1,357	751	654	461	871	4,093	71%
Jon 2	780	780	0	780	780	780	780	0	780	819	6,279
2017-2018	780	780	0	780	780	0	0	0	0	0	3,120
2018-2019	0	0	0	0	0	780	780	0	780	819	3,159	1%
shapadowa	0	0	0	0	0	450	769	653	467	587	2,926
2018-2019	0	0	0	0	0	450	769	653	467	587	2,926
rgv	1,047	0	875	0	265	899	0	510	0	410	4,005
2017-2018	1,047	0	875	0	265	0	0	0	0	0	2,186
2018-2019	0	0	0	0	0	899	0	510	0	410	1,819	-17%
sample six	180	180	360	360	180	300	0	480	0	240	2,280
2017-2018	180	180	360	360	180	0	0	0	0	0	1,260
2018-2019	0	0	0	0	0	300	0	480	0	240	1,020	-19%

<tbody>
</tbody>

hi can you see what im trying to analyse from this sample and does it look correct using the ABS formula

formula is =(L5-L4)/ABS(L4)

cheers

 

[r1998]

Hello Scrumpywill
in N3 use this formula and drag down till N21

=(L3*100/L2)-100

this will give the % increase or decrease

 

[Scrumpywill]

Do you think this is better than the abs formula? Only you don’t get a decimal point in the formatting text & percent % in the text

 

[r1998]

As long as we are getting the correct answer, both seem to be fine
if you want a decimal in your answer, you can format the cell as Percentage with 2 decimal places, so then you will have 2 decimals along with the % sign too

 

[Scrumpywill]

Thank you for all your help, how would you display on a graph