LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
F.
 
Posts: n/a
Default result is Zero on every maths functions - sum, multiplication ... etc

Hi all
Thank you M. Philips, that's right, I made a mistake about the NG.

So, I have this problem :
Whenever I use numbers functions, I got a 0 result whether like this :
Cell A = "=5+6" = give 0 instead of 11
or
Cell T = "=5*6" = give 0 instead of 30
or like this :
Cell D = SUM(C3:C7) = 0
thus, even if the cells sum is not 0 and that the cells do not contain
text but number (checked already).

Which option is involved in this process ?

Thanks in advance.
Best regards
F.

================================================== ===============
Bonjour,

Généralement, c'est un NG d'expression anglaise. Essayez le groupe à
microsoft.public.fr.excel

Bonne chance

--

HTH

RP
(remove nothere from the email address if mailing direct)


"F." wrote in message
om...
Bonjour

J'ai le problème suivant.
En exécutant une fonction mathématique sur une cellule contenant un nombre,
que ce soit directement "=5+6" ou "=5*6" ou indirectement SOMME(C3:C7)
me renvoie un zéro. Les cellules n'ont pas de texte en guise de nombre (vérifié).

Avez vous une idée de l'option qui est incorrectement paramétrée ?

Cordialement,
F.

 
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
Amount or Numbers in Words ron New Users to Excel 6 December 24th 04 07:32 PM
Is there a formula to spell out a number in excel? Sha-nay-nay Excel Worksheet Functions 2 December 18th 04 09:25 PM
Convert Numeric into Text Monty Excel Worksheet Functions 0 December 18th 04 09:25 PM
Spellnumber Norman Jones Excel Worksheet Functions 6 December 13th 04 07:21 AM
is there a instrRev function in excel functions? schuurke28 Excel Worksheet Functions 1 October 28th 04 03:05 PM


All times are GMT +1. The time now is 12:31 PM.

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

About Us

"It's about Microsoft Excel"