| Home |
| Search |
| Today's Posts |
|
#1
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
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
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?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display of formula result | Excel Worksheet Functions | |||
| How do I display 0 if it is the end result for a formula | Excel Discussion (Misc queries) | |||
| Want to display financial formula result... not the formula | Excel Worksheet Functions | |||
| Display result of formula in header? | Excel Discussion (Misc queries) | |||
| How do I display the RESULT of a formula | New Users to Excel | |||
Linear Mode
