Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sum command do not display the result eg:=sum(c5:c8)-total not
sum command do not display the result eg:=sum(c5:c8)-total not display the
result in the cell even when sigma is clicked the same |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sum command do not display the result eg:=sum(c5:c8)-total not
What is displayed instead?
If you see the formula, then format the cell as General (or anything but text) and reenter that formula. If you see the wrong answer, then maybe you have calculation set to manual. Tools|Option|calculation tab is how you'd change it in xl2003 menus. If that's not it, then maybe your values in those cells (C5:C8) aren't really numbers. Reformat that range as General (not text) and reenter the values. abbbalu wrote: sum command do not display the result eg:=sum(c5:c8)-total not display the result in the cell even when sigma is clicked the same -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup command not giving the correct result | Excel Worksheet Functions | |||
How do I get the command sets to automatically display? | Excel Discussion (Misc queries) | |||
how do i use 'if' command to display answer in different cell? | Excel Discussion (Misc queries) | |||
display total above certain number and display | Excel Discussion (Misc queries) | |||
Display result as Yes or No | Excel Worksheet Functions |