Thread: CELL UPDATING
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
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