Cell won't calculate/does not include value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sometimes when I enter a formula in a cell, it displays the textual formula instead of the result. (Usually this is a Summation). Re-entering does not correct the problem but I can usually find a workaround by using an adjacent cell or using the long form (e.g. a+b-c...). In other cases, the result does appear but isn't included in a calculation of the entire column. Does anyone know what causes these problems and/or how to fix???

thanks,

oldgene
 
Sometimes when I enter a formula in a cell, it displays the textual
formula instead of the result. (Usually this is a Summation).
Re-entering does not correct the problem but I can usually find a
workaround by using an adjacent cell or using the long form (e.g.
a+b-c...). In other cases, the result does appear but isn't included
in a calculation of the entire column. Does anyone know what causes
these problems and/or how to fix???
Click to expand...

Do you have a spreadsheet that exhibits this problem consistently in one or
more cells?
 
Back
Top