Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 35,218
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup command not giving the correct result VKL Narayanan[_2_] Excel Worksheet Functions 2 November 1st 08 11:48 AM
How do I get the command sets to automatically display? SB Excel Discussion (Misc queries) 1 August 6th 08 06:40 PM
how do i use 'if' command to display answer in different cell? Fred Far Excel Discussion (Misc queries) 4 March 10th 06 01:27 PM
display total above certain number and display MGD Excel Discussion (Misc queries) 3 March 4th 06 05:03 PM
Display result as Yes or No Pat Excel Worksheet Functions 1 November 1st 04 02:35 PM


All times are GMT +1. The time now is 09:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"