|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 6th, 2008, 10:29 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
How do I display a formula result without losing the formula?
Often in Excel 2003, I'm unable to see the result (value) of a formula (ie.
countif, counta). The only way I've found to actually see the result is to copy the formula and then special paste it as a value. However, I end up losing the formula when I do that, so I'm not able to get an updated result without always re-doing the formula. Does anyone have any advice, or is this just an Excel 2003 glitch?? 
|
|
#2
November 6th, 2008, 10:36 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I display a formula result without losing the formula?
Suppose you have the following formula in A1
=B1+C1 and B1=5, C1=1 you should see 6 in A1... If you see =B1+C1 then try to press CTRL-` once ` is on the top-left corner of the keyboard with ~ on the same key... If the value does not change if you change B1 and/or C1 then press F9. Also check the setting in Tools|Options|Calculation... It should be automatic... "mamajazz" wrote: Often in Excel 2003, I'm unable to see the result (value) of a formula (ie. countif, counta). The only way I've found to actually see the result is to copy the formula and then special paste it as a value. However, I end up losing the formula when I do that, so I'm not able to get an updated result without always re-doing the formula. Does anyone have any advice, or is this just an Excel 2003 glitch??
|
|
#3
November 7th, 2008, 03:07 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I display a formula result without losing the formula?
Thank you! We tried that yesterday and it didn't work. This morning, I
tried again and it worked! Strange... "Sheeloo" wrote: Suppose you have the following formula in A1 =B1+C1 and B1=5, C1=1 you should see 6 in A1... If you see =B1+C1 then try to press CTRL-` once ` is on the top-left corner of the keyboard with ~ on the same key... If the value does not change if you change B1 and/or C1 then press F9. Also check the setting in Tools|Options|Calculation... It should be automatic... "mamajazz" wrote: Often in Excel 2003, I'm unable to see the result (value) of a formula (ie. countif, counta). The only way I've found to actually see the result is to copy the formula and then special paste it as a value. However, I end up losing the formula when I do that, so I'm not able to get an updated result without always re-doing the formula. Does anyone have any advice, or is this just an Excel 2003 glitch??
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
