#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 17
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,440
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,572
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating a cell JonathanW Excel Discussion (Misc queries) 1 March 22nd 07 04:31 AM
updating a cell value Ray H. Excel Discussion (Misc queries) 2 February 2nd 06 04:55 AM
Updating one cell with a formula Shivers Excel Worksheet Functions 2 January 26th 06 05:36 PM
Updating the Sum of a cell Teddy54 Excel Worksheet Functions 0 November 18th 05 11:01 PM
Updating the Sum of a cell Teddy54 Excel Worksheet Functions 2 November 18th 05 10:12 PM


All times are GMT +1. The time now is 12:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"