Excel Spreadsheets formulas don't update
in [General]
|
From: GGirl on 20 Apr 2010 22:22 Can anyone suggest how my formula are in active suddenly. If I had 1+1+2, and change one of the numbers to 1+2, I still get 2 in the sum.
From: L. Howard Kittle on 20 Apr 2010 23:39 If you put 1+1+2 in a cell it will return "1+1+2." If you put =1+1+2 in a cell it will return 4 <change one of the numbers to 1+2, I still get 2 in the sum.> Makes no sense to me how you "still get 2 in the sum"???? Regards, Howard "GGirl" <GGirl(a)discussions.microsoft.com> wrote in message news:A2721A4E-479C-43A9-896E-CEC3C6E71CD0(a)microsoft.com... > Can anyone suggest how my formula are in active suddenly. If I had 1+1+2, > and > change one of the numbers to 1+2, I still get 2 in the sum.
From: grizzly6969 on 21 Apr 2010 01:49 not knowing what your formula is but check Tools / Options / Calculations and Automatic should be checked -- grizz "GGirl" wrote: > Can anyone suggest how my formula are in active suddenly. If I had 1+1+2, and > change one of the numbers to 1+2, I still get 2 in the sum.
|
Pages: 1 Prev: Search and Replace, or Add New Row Next: Excel Spreadsheets formulas don't update |