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
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