Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating a cell | Excel Discussion (Misc queries) | |||
updating a cell value | Excel Discussion (Misc queries) | |||
Updating one cell with a formula | Excel Worksheet Functions | |||
Updating the Sum of a cell | Excel Worksheet Functions | |||
Updating the Sum of a cell | Excel Worksheet Functions |