Formulas not working

  • Thread starter Thread starter SJBhatia
  • Start date Start date
S

SJBhatia

I have a 3-column petty cash log.

Column A is debits
Column B is credits
Columb C is balance

Cell C2 contains the formula: =SUM(C1+A2-B2)

when I copy/paste, or drag the formula into C3, it simply copies th
value from C2 without doing the calculation.

I have noticed that this is the case on some workstations, but not o
all. I have tried copying my data to a new sheet, in fact I've eve
tried creating a new workbook to test if formulas are working at al
and they're not.

Any help would be much appreciated - this is very bizarre, never see
anything like it.

Thanks in advance,


SJB
 
Hi
first: You don*'t need SUM in your formula. Change your
formula to
=C1+A2-B2

For your problem: Check if automatic calculation is
enabled (goto 'Tools - Options - Calculate' and check this
option)
 
Back
Top