1854 Views 6 Replies Latest reply: Mar 26, 2010 10:11 AM by KOENIG Yvan
My guess is that the error is in your document, not in Numbers.
If you get 0.00 and not a red triangle, it's that your formula grabs datas from existing empty cells.
You may send the document to my mailbox if you wish that I try to find the error.
If datas are 'confidential', you may replace them by fake ones.
Click my blue name to get my address.
Yvan KOENIG (VALLAURIS, France) jeudi 25 mars 2010 17:44:13
Without seeing it, it's hard to tell what's going wrong. Two possibilities are
1) The numbers to be summed are in cells formatted as text. Text, even if it is a numeral, will not sum.
2) One or more of the test conditions is not exactly the same as what is in the table. Case doesn't matter but maybe there is a trailing space or an extra space somewhere in the word in your table or in your formula.
This is the response I received from KOENIG a few minutes ago via a private email (Because I can't post screens shots on here due to the fact that I have no public sharing capabilities. On the other hand, screen shots would not have help since one had to physically open the file to pick up the mistake I made). Obviously not a bug in numbers, but extra spaces. I quote KOENIG:
In your popup menu, the menu item is not "Clothing" but "Clothing ". The extraneous space made the difference.
For Gas, it's the opposite.
The popup menu item is correctly "Gas" but the cell A27 of Overview ;; Table 1 contains "Gas " . The extraneous space made the difference.
As I'm very busy I ask you to post the response in the forum so that other helpers will not continue to scrap their head trying to understand.
Yvan KOENIG (VALLAURIS, France) vendredi 26 mars 2010 11:16:05"
At last I have responded to the 50 mails received and finished what I had to do in the garden.
I wish to add that when something doesn't behave as we wish, 99.99% of times, it's because we made a typo.
Here is a list of common ones :
(1) Extraneous spaces
(2) Unwanted duplicated chars
(3) unwanted or missing parenthesis (or double quotes)
(4) Error with the parameters separator (semi-colon versus comma)
(5) add you own common ones
Case 3 is quite easy to identify because most of the times, it generates a syntax error.
Case 4 is easier to identify because, as far as I know, it always generates a syntax error.
I apologizes but I can't describe Case 5's behaviour
Case 1 and 2 are the more annoying because they may give a formula returning a wrong value without any kind of error message.
It may be a good idea to keep this list near your machine.
Yvan KOENIG (VALLAURIS, France) vendredi 26 mars 2010 18:09:36