Thread: Why is my formula is not calculating, it works in other areas?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sandarm
 
Posts: n/a
Default 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?
Reply With QuoteReply With Quote