| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
EXCEL ANSWER TO FORMULA DOES NOT SHOW UP
I set up a formula adding a set of numbers in a column, e.g.=sum(c1:c34).
The formula is correct but I got a zero as an answer. I set up the same formula in another column and it gives me the correct answer, e.g. $2,500. I tried copying this formula to the first one on the same row. And it returns $2,500. What is going on? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I show complete answer column | Excel Discussion (Misc queries) | |||
| can excel show only the answer to a formula in the cell | Excel Discussion (Misc queries) | |||
| Need a formula to calculate greater than & show answer as a % | Excel Worksheet Functions | |||
| multiply two numbers and show the answer in a textbox | Excel Discussion (Misc queries) | |||
| How to show the formula and the answer? | Excel Discussion (Misc queries) | |||
Threaded Mode
