Calc - Sum subtracts 1 from total [closed]

calc
sum

asked 2014-10-22 22:04:40 +0100

ophiyuki
1 ●1 ●1 ●1

I am using Sum to add the total of a row. Instead of the total, sum actually gives me a number that is less 1. For example, I have a row that should add up to 6. The total it is giving me is 5. What did I do wrong?

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-03-05 09:38:14.476196

add a comment

1 Answer

Sort by » oldest newest most voted

answered 2014-10-22 23:27:34 +0100

Rugslug

1341 ●5 ●12 ●22

You will have to supply more information, precisely what you have done and what numbers you are using.

One possibility may be that the actual values of the numbers in the cells are not what you are seeing.

For example, 0.5+0.4+0.5+0.8+0.9=3

However, if these if I change the decimal display to a whole number they appear to be: 1+0+1+1+1. However, the sum of these numbers will be 3 because of the actual values as shown above.

The image below shows the buttons I used to increase or decrease the decimals.

image description

edit flag offensive delete link

add a comment

Question Tools

1 follower

Stats

Asked: 2014-10-22 22:04:40 +0100

Seen: 377 times

Last updated: Oct 22 '14

Calc - Sum subtracts 1 from total [closed] edit

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2016-03-05 09:38:14.476196

1 Answer

Question Tools

Stats

Related questions

Calc - Sum subtracts 1 from total [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-05 09:38:14.476196