CELL UPDATING
 

Hello all

In Excell i need help from u all

i have three cells

1st cell= 1000
2nd cell=10
3rd cell= (1st cell -2nd cell)

now i get in 3rd cell as 990
if again i give 20 in 2nd cell
the third cell shouls display as 970 not 980

how to do this in excell
please help me

Reagrds
Bala

CELL UPDATING
 

???
1000 - 20 = 980
???
--
Gary''s Student - gsnu200762


"Bala" wrote:

Hello all

In Excell i need help from u all

i have three cells

1st cell= 1000
2nd cell=10
3rd cell= (1st cell -2nd cell)

now i get in 3rd cell as 990
if again i give 20 in 2nd cell
the third cell shouls display as 970 not 980

how to do this in excell
please help me

Reagrds
Bala

CELL UPDATING
 

Hi Bala,

Look he

http://www.mcgimpsey.com/excel/accumulator.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Bala" wrote in message ...
| Hello all
|
| In Excell i need help from u all
|
| i have three cells
|
| 1st cell= 1000
| 2nd cell=10
| 3rd cell= (1st cell -2nd cell)
|
| now i get in 3rd cell as 990
| if again i give 20 in 2nd cell
| the third cell shouls display as 970 not 980
|
| how to do this in excell
| please help me
|
| Reagrds
| Bala

CELL UPDATING
 

Check to see if your calc mode is set to automatic.

From the Menu Bar:
<Tools <Options <Calculation tab,
And make sure "Automatic" is checked.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Bala" wrote in message
...
Hello all

In Excell i need help from u all

i have three cells

1st cell= 1000
2nd cell=10
3rd cell= (1st cell -2nd cell)

now i get in 3rd cell as 990
if again i give 20 in 2nd cell
the third cell shouls display as 970 not 980

how to do this in excell
please help me

Reagrds
Bala