CELL UPDATING

  • Thread starter Thread starter Bala
  • Start date Start date
B

Bala

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
 
Hi Bala,

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

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