Ask Your Question

wrong formula results in Calc or I am doing something wrong? [closed]

asked 2014-02-08 18:43:43 +0200

Ljiljan gravatar image

I have different grades (5, 6, 7, 8, 9 and 10) in sheet 1. I use simple function "countif" to count grades and then to calculate percentage. However, this happened twice (see photo).

image description

When second grades is entered in sheet 1, everything is working fine (even after I delete that grade, and still have only one grade). Any idea why is this happening?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 09:37:34.755801


How do you enter the numbers is in column C? By hand exact as they appear, calculated and displayed as "0" or "1". If they are calculated and rounded to 0, 1 you might have some real value there that give you a result <>0.

horst gravatar imagehorst ( 2014-02-08 23:56:12 +0200 )edit

Can you include an example of what is in the "Broj" (COUNTIF) column? Would seem like the displayed zero is not actually a zero or that the COUNTIF is not returning what is expected? What is the format of the "Broj" column? EDIT: Did not see the comment by @horst. My question is the same, just worded differently.

oweng gravatar imageoweng ( 2014-02-09 00:13:15 +0200 )edit

This is the column C7. "=COUNTIF($Ocjene.$AB$4:$AB$173;B7)" and B7 is just number "7". I've already had an Calc document with two sheets (Ocjene and Statistika)... after an makeup exam, I deleted all grades from students and then started entering the new one... and that is when it happened.

Ljiljan gravatar imageLjiljan ( 2014-02-09 09:56:48 +0200 )edit

I will check if it's possible to reproduce this error and then upload file here

Ljiljan gravatar imageLjiljan ( 2014-02-09 09:58:23 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-02-09 23:02:06 +0200

horst gravatar image

Hi @Ljiljan, try to recalculate the whole document by pressing Shift+Ctrl+F9. There might be old data left over.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-02-08 18:43:43 +0200

Seen: 706 times

Last updated: Feb 09 '14