Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |