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 NA or something like that in the calculation because there is no data available yet.

Please help.

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

​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 NA or something like that in the calculation because there is no data available yet. Please help.  ABCDE1FY24 Q1529FY24 Q11065 2FY24 Q2324FY24 Q2375 3FY24 Q3555FY24 Q30 4FY24 Q4868FY24 Q40   Read More

​