Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
fromula error
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula error
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
fromula error
It is possible that you have automatic calculation turned off. Try pressing
F9 and see if that forces calculation. If it does then find workbook calculation in Options and set it to automatic. If you can't find where to set the options then reply with the version of Excel that you are using. -- Regards, OssieMac "Bhavin" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
fromula error
Press F9 key to see if it produce the desired result, if it does then
Your caculation is turn on to Manual. To turn this to automatic Go to Tool Options Calculation check on Automatic -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "Bhavin" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fromula bar | Excel Discussion (Misc queries) | |||
Using Array Fromula | Excel Discussion (Misc queries) | |||
Fromula | Excel Discussion (Misc queries) | |||
Array Fromula | Excel Worksheet Functions | |||
Need a fromula | Excel Discussion (Misc queries) |