Hi Bhavin,

Given the typos in your post, are you sure you're typing the formula correctly? If you are, check that calculation is set to
'automatic' (Tools|Options|Calculation) and that the cells concerned are not formatted as text (Format|Cells|Number).

--
Cheers
macropod
[Microsoft MVP - Word]


"Bhavin" wrote in message ...
hi i m having a problem with excel sheet.recently when any formul is entered
in a cell, the result doesnt change when the value of the cell is changed.
for e.g. in a formula cell C4=b4+a4, the value of b4 is 50 & a4 is 40 the
resullt comes to 90 only for the first time. whenever the value of either a4
or b4 is changed the result in c4 doesnt change.i.e. when value of b4 is
modified to 70 from 50 it doesnt have the effect on the result.how to solve
this problem. earlier i was not having such problem.please guide me, thanks.