How do I display a formula result without losing the formula?

M

mamajazz

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??
 
S

Sheeloo

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...
 
M

mamajazz

Thank you! We tried that yesterday and it didn't work. This morning, I
tried again and it worked! Strange...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Want to sort by formula value without losing formula 4
Hide Formula & Allow Copy 1
Excel Create a New line in a Word Link without double "" around result 0
Formula result not displaying correctly 2
Countif result problem 4
Paste Special Formula Multiply feature doesn't work anymore 2
How do I use a formula result in another formula 2
Formula in Cell Instead of Result 3

Top