Forum Discussion

lfk73's avatar
lfk73
Copper Contributor
Oct 16, 2024

Really dumb question - Percentage increase\decreased calcualtion

I have a simple enough question but cant seem to work out how to get it right.

 

I cant to calculate the percentage increase (or decrease) between the 2 numbers in each row and put that into column E on the same row.  I'm guessing put a formula in cell E1 and then cascade that formula down.

 

If there is a 0 in any of the cells e.g. rows 3 and 4 I want a N\A or something like that in the calculation because there is no data available yet.

 

Please help.

 

 ABCDE
1FY24 Q1529FY24 Q11065 
2FY24 Q2324FY24 Q2375 
3FY24 Q3555FY24 Q30 
4FY24 Q4868FY24 Q40 

Resources