Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas to Values
What might cause, and how can I stop formulas from being automatically
converted to values? When I enter a formula into a cell, it is immediately stored as the RESULT, not the actual formula. This is not consistent, even with formulas that are "COPY-DOWN" [<Ctrl-D] in the same column. Some formulas remain and some convert to their resulting value. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas to Values
Do you mean that when you look in the Formula Bar you see a value, not a
formula? Cell, of course, normally show values If you tell us more we might be able to help Any change you have a lurking macro? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "DJaded" wrote in message ... What might cause, and how can I stop formulas from being automatically converted to values? When I enter a formula into a cell, it is immediately stored as the RESULT, not the actual formula. This is not consistent, even with formulas that are "COPY-DOWN" [<Ctrl-D] in the same column. Some formulas remain and some convert to their resulting value. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas to Values
would you elaborate on what you want to achieve?
do you want to show the result of the formula or you want to show the formula itself? "DJaded" wrote: What might cause, and how can I stop formulas from being automatically converted to values? When I enter a formula into a cell, it is immediately stored as the RESULT, not the actual formula. This is not consistent, even with formulas that are "COPY-DOWN" [<Ctrl-D] in the same column. Some formulas remain and some convert to their resulting value. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas to Values
The formula bar shows the result. Subsequently, changing the values in the
cells referenced by the original formula will not change the value in the cell. "Bernard Liengme" wrote: Do you mean that when you look in the Formula Bar you see a value, not a formula? Cell, of course, normally show values If you tell us more we might be able to help Any change you have a lurking macro? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "DJaded" wrote in message ... What might cause, and how can I stop formulas from being automatically converted to values? When I enter a formula into a cell, it is immediately stored as the RESULT, not the actual formula. This is not consistent, even with formulas that are "COPY-DOWN" [<Ctrl-D] in the same column. Some formulas remain and some convert to their resulting value. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas to Values
I typed the formula "=TEXT(IF(DL61+DM61=0,0,DL61/(DL61+DM61)),"0.000")" into
cell DO61. When I hit <enter, the cell value shows "0.700" and the formula bar shows "0.7". I'm trying to determine a Won/Lost percentage that will re-calculate when I change the Won/Lost record. Obviously, if the formula is replaced by the current value, changing the record will not change the percentage. "franciz" wrote: would you elaborate on what you want to achieve? do you want to show the result of the formula or you want to show the formula itself? "DJaded" wrote: What might cause, and how can I stop formulas from being automatically converted to values? When I enter a formula into a cell, it is immediately stored as the RESULT, not the actual formula. This is not consistent, even with formulas that are "COPY-DOWN" [<Ctrl-D] in the same column. Some formulas remain and some convert to their resulting value. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas to Values
Hi,
My apology as I was away for the past week. I am still not sure what you are trying to achieve. Are you saying that when you change the referenced value in DL61 or DM61, the value in DO61 doesn't change? I tried this by changing the value and the resultant value does change. If this is not what you are after, pls describe your data table and the result you want. "DJaded" wrote: I typed the formula "=TEXT(IF(DL61+DM61=0,0,DL61/(DL61+DM61)),"0.000")" into cell DO61. When I hit <enter, the cell value shows "0.700" and the formula bar shows "0.7". I'm trying to determine a Won/Lost percentage that will re-calculate when I change the Won/Lost record. Obviously, if the formula is replaced by the current value, changing the record will not change the percentage. "franciz" wrote: would you elaborate on what you want to achieve? do you want to show the result of the formula or you want to show the formula itself? "DJaded" wrote: What might cause, and how can I stop formulas from being automatically converted to values? When I enter a formula into a cell, it is immediately stored as the RESULT, not the actual formula. This is not consistent, even with formulas that are "COPY-DOWN" [<Ctrl-D] in the same column. Some formulas remain and some convert to their resulting value. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas to Values
Quite simply, I would like the "value" in cell DO61 to a calculated
percentage based on cells DL61 and DM61. When I enter the necessary formlua into cell DO61, the formula is immediately converted to the current value, as if I had done a PasteSpecial-Values. Cell DO61 no longer contains the formula - It contains the result! "xlmate" wrote: Hi, My apology as I was away for the past week. I am still not sure what you are trying to achieve. Are you saying that when you change the referenced value in DL61 or DM61, the value in DO61 doesn't change? I tried this by changing the value and the resultant value does change. If this is not what you are after, pls describe your data table and the result you want. "DJaded" wrote: I typed the formula "=TEXT(IF(DL61+DM61=0,0,DL61/(DL61+DM61)),"0.000")" into cell DO61. When I hit <enter, the cell value shows "0.700" and the formula bar shows "0.7". I'm trying to determine a Won/Lost percentage that will re-calculate when I change the Won/Lost record. Obviously, if the formula is replaced by the current value, changing the record will not change the percentage. "franciz" wrote: would you elaborate on what you want to achieve? do you want to show the result of the formula or you want to show the formula itself? "DJaded" wrote: What might cause, and how can I stop formulas from being automatically converted to values? When I enter a formula into a cell, it is immediately stored as the RESULT, not the actual formula. This is not consistent, even with formulas that are "COPY-DOWN" [<Ctrl-D] in the same column. Some formulas remain and some convert to their resulting value. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas to Values
I have tried this formula and its remain as formula in the cell.
Try checking the format of you cells by right clicking Format Cells change it to General Does this help? Pls click Yes if it does cheers "DJaded" wrote: Quite simply, I would like the "value" in cell DO61 to a calculated percentage based on cells DL61 and DM61. When I enter the necessary formlua into cell DO61, the formula is immediately converted to the current value, as if I had done a PasteSpecial-Values. Cell DO61 no longer contains the formula - It contains the result! "xlmate" wrote: Hi, My apology as I was away for the past week. I am still not sure what you are trying to achieve. Are you saying that when you change the referenced value in DL61 or DM61, the value in DO61 doesn't change? I tried this by changing the value and the resultant value does change. If this is not what you are after, pls describe your data table and the result you want. "DJaded" wrote: I typed the formula "=TEXT(IF(DL61+DM61=0,0,DL61/(DL61+DM61)),"0.000")" into cell DO61. When I hit <enter, the cell value shows "0.700" and the formula bar shows "0.7". I'm trying to determine a Won/Lost percentage that will re-calculate when I change the Won/Lost record. Obviously, if the formula is replaced by the current value, changing the record will not change the percentage. "franciz" wrote: would you elaborate on what you want to achieve? do you want to show the result of the formula or you want to show the formula itself? "DJaded" wrote: What might cause, and how can I stop formulas from being automatically converted to values? When I enter a formula into a cell, it is immediately stored as the RESULT, not the actual formula. This is not consistent, even with formulas that are "COPY-DOWN" [<Ctrl-D] in the same column. Some formulas remain and some convert to their resulting value. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas to Values
No, this does NOT help. The only thing that [partially] helps is to actually
DELETE the cells in the table and reapply the formula. However, when I post new values to the source cells, the formulas are again converted to their values. Bottom line, though, is you have no answer to the original question, Right? "xlmate" wrote: I have tried this formula and its remain as formula in the cell. Try checking the format of you cells by right clicking Format Cells change it to General Does this help? Pls click Yes if it does cheers "DJaded" wrote: Quite simply, I would like the "value" in cell DO61 to a calculated percentage based on cells DL61 and DM61. When I enter the necessary formlua into cell DO61, the formula is immediately converted to the current value, as if I had done a PasteSpecial-Values. Cell DO61 no longer contains the formula - It contains the result! "xlmate" wrote: Hi, My apology as I was away for the past week. I am still not sure what you are trying to achieve. Are you saying that when you change the referenced value in DL61 or DM61, the value in DO61 doesn't change? I tried this by changing the value and the resultant value does change. If this is not what you are after, pls describe your data table and the result you want. "DJaded" wrote: I typed the formula "=TEXT(IF(DL61+DM61=0,0,DL61/(DL61+DM61)),"0.000")" into cell DO61. When I hit <enter, the cell value shows "0.700" and the formula bar shows "0.7". I'm trying to determine a Won/Lost percentage that will re-calculate when I change the Won/Lost record. Obviously, if the formula is replaced by the current value, changing the record will not change the percentage. "franciz" wrote: would you elaborate on what you want to achieve? do you want to show the result of the formula or you want to show the formula itself? "DJaded" wrote: What might cause, and how can I stop formulas from being automatically converted to values? When I enter a formula into a cell, it is immediately stored as the RESULT, not the actual formula. This is not consistent, even with formulas that are "COPY-DOWN" [<Ctrl-D] in the same column. Some formulas remain and some convert to their resulting value. |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas to Values
My apology. The result did changed when I changes the value in source cells
using the your formula. You may want to consider removing the TEXT function in your formula "=IF(DL61+DM61=0,0,DL61/(DL61+DM61)) and format the result to 3 decimals Why do you need to use the TEXT function in your formula? Hope this help "DJaded" wrote: No, this does NOT help. The only thing that [partially] helps is to actually DELETE the cells in the table and reapply the formula. However, when I post new values to the source cells, the formulas are again converted to their values. Bottom line, though, is you have no answer to the original question, Right? "xlmate" wrote: I have tried this formula and its remain as formula in the cell. Try checking the format of you cells by right clicking Format Cells change it to General Does this help? Pls click Yes if it does cheers "DJaded" wrote: Quite simply, I would like the "value" in cell DO61 to a calculated percentage based on cells DL61 and DM61. When I enter the necessary formlua into cell DO61, the formula is immediately converted to the current value, as if I had done a PasteSpecial-Values. Cell DO61 no longer contains the formula - It contains the result! "xlmate" wrote: Hi, My apology as I was away for the past week. I am still not sure what you are trying to achieve. Are you saying that when you change the referenced value in DL61 or DM61, the value in DO61 doesn't change? I tried this by changing the value and the resultant value does change. If this is not what you are after, pls describe your data table and the result you want. "DJaded" wrote: I typed the formula "=TEXT(IF(DL61+DM61=0,0,DL61/(DL61+DM61)),"0.000")" into cell DO61. When I hit <enter, the cell value shows "0.700" and the formula bar shows "0.7". I'm trying to determine a Won/Lost percentage that will re-calculate when I change the Won/Lost record. Obviously, if the formula is replaced by the current value, changing the record will not change the percentage. "franciz" wrote: would you elaborate on what you want to achieve? do you want to show the result of the formula or you want to show the formula itself? "DJaded" wrote: What might cause, and how can I stop formulas from being automatically converted to values? When I enter a formula into a cell, it is immediately stored as the RESULT, not the actual formula. This is not consistent, even with formulas that are "COPY-DOWN" [<Ctrl-D] in the same column. Some formulas remain and some convert to their resulting value. |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas to Values
I am not offerring a solution. Instead, I have the same problem, and from the
correspondence that followed this posting, I still do not see a solution. Also, in my case the changing from formula to value seems to occur "randomly", meaning it is OK after x number of calculations, then "puff" it changed to a value. Yes, "clear contents" of the cell allows you to write a formula, but then the same thing as mentioned above, happens. Can some one help, PLEASE? Either tell me what to do, or point where the solution has been shown. Thanks Albert Liem PS I have been using MSExcel 2003 for some time, and never saw this happen. Now I use MS Excel 2007 and Vista. Prgress???!!! "DJaded" wrote: What might cause, and how can I stop formulas from being automatically converted to values? When I enter a formula into a cell, it is immediately stored as the RESULT, not the actual formula. This is not consistent, even with formulas that are "COPY-DOWN" [<Ctrl-D] in the same column. Some formulas remain and some convert to their resulting value. |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas to Values
I am not offering a solution. Instead I have the same problem, and have not
seen a solution in this series of correspondence or other places that I have searched thus far. HELP, please? Note: I have used Excel 2003 for a long time and never saw this happen. Now I use 2007 and VISTA. Progress, huh???!!! "DJaded" wrote: What might cause, and how can I stop formulas from being automatically converted to values? When I enter a formula into a cell, it is immediately stored as the RESULT, not the actual formula. This is not consistent, even with formulas that are "COPY-DOWN" [<Ctrl-D] in the same column. Some formulas remain and some convert to their resulting value. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep Values and Formulas | Excel Worksheet Functions | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
values in IF formulas | Excel Worksheet Functions | |||
Formulas as Values | Excel Discussion (Misc queries) | |||
Formulas with "Y" & "N" values | Excel Discussion (Misc queries) |