How to sum the current and previous Value of a cell

[Guest Bindu Kalarikal]

Hi,

 

I want to add up the current and previous value of a cell.

 

eg:

A1 = 2

Then B1 should reflect 2

but when we change the value of A1 to 1, then B1 shud reflect 2+1=3(ie

previous value+current value)

 

Please help me out with this.

 

Binz

[Guest Meinolf Weber]

Re: How to sum the current and previous Value of a cell

 

Hello Bindu,

 

What has this to do with 2000 general? Better post to:

microsoft.public.excel

 

Best regards

 

Meinolf Weber

Disclaimer: This posting is provided "AS IS" with no warranties, and confers

no rights.

** Please do NOT email, only reply to Newsgroups

** HELP us help YOU!!! http://www.blakjak.demon.co.uk/mul_crss.htm

> Hi,

>

> I want to add up the current and previous value of a cell.

>

> eg:

> A1 = 2

> Then B1 should reflect 2

> but when we change the value of A1 to 1, then B1 shud reflect 2+1=3(ie

> previous value+current value)

> Please help me out with this.

>

> Binz

>