Why is my formula is not calculating, it works in other areas?
 

I use a simple formula: =(b1/a1)-1 to calculate percentage difference. It
normally works just fine, but for some reason is not working now. It works in
my other spreadsheets and even in other areas of the same sheet. I have tried
re-entering it rather than copying it but still no luck. Any ideas?

Why is my formula is not calculating, it works in other areas?
 

Try clearing cell content and reenter the formula. There maybe be somthing
there that is causing the problem.

"sandarm" wrote:

I use a simple formula: =(b1/a1)-1 to calculate percentage difference. It
normally works just fine, but for some reason is not working now. It works in
my other spreadsheets and even in other areas of the same sheet. I have tried
re-entering it rather than copying it but still no luck. Any ideas?