I have a spreadsheet that looks like this.
I am trying to calculate the percentage change between a1 and b1
Normally, I just do;
Since A1 is 0, I cannot divide by A1. What would be the formula to use that would give me the correct answer. I believe it would be 100% (I think)