Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default The formula does not calculate properly... Help me if you could..

When I click on the formula button it appears all right but does not
calculate values of cells... could anyone help me???
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,339
Default The formula does not calculate properly... Help me if you could..

... and the formulae (and values) are ...?

"xokaido" wrote:

When I click on the formula button it appears all right but does not
calculate values of cells... could anyone help me???

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 57
Default The formula does not calculate properly... Help me if you could..

see later posting

--
Regards
Roger Govier



"xokaido" wrote in message
...
When I click on the formula button it appears all right but does not
calculate values of cells... could anyone help me???



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default The formula does not calculate properly... Help me if you coul

I want to sum column A... Got row with "Total"... When click on the formula
button (on the toolbar) it appears that all`s right...But does not calculate
values (a numbers in the cells)...
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default The formula does not calculate properly... Help me if you could..

Make sure your cell isn't formatted as text.
Make sure there aren't spare spaces or other non-printing characters before
the equals sign at the start of the formula.
Press CTRL + ` (grave accent) to toggle between displaying the formula or
its result.
--
David Biddulph

"xokaido" wrote in message
...
When I click on the formula button it appears all right but does not
calculate values of cells... could anyone help me???



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
Formula won't calculate Be18 Excel Discussion (Misc queries) 3 March 2nd 07 12:47 AM
Excel should calculate exponentials properly (right to left) expatrie Excel Worksheet Functions 5 April 26th 06 08:34 AM
How do I calculate a formula once Pavlova Excel Worksheet Functions 0 November 15th 05 12:19 PM
Sum formula is not adding up properly Michelle Excel Discussion (Misc queries) 4 November 4th 05 11:18 AM
How to calculate/properly display significant figures ending in 0 A Zaffiro Excel Worksheet Functions 5 June 28th 05 08:36 PM


All times are GMT +1. The time now is 09:59 AM.

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"