Does LibreOffice Calc have a default multiplier setting? [closed]

asked 2020-01-17 14:05:06 +0100

DEBCal gravatar image

updated 2020-01-17 15:51:32 +0100

ebot gravatar image

My wife brought this to my attention in a spreadsheet she is busy with and I have repeated the "error" on her machine and my machine. When using the "sum" formula, if one of the numbers is changed to a negative number, the "sum" formula first multiplies by 2 and then subtracts. Where does this 2 multiplier come from? C:\fakepath\test.ods

A1 - 10
A2 - 20
A3 - 30
A4 - 40
A5 - 50
A6 - 60
A7 - =sum(a1:a6)

Result = 210 (correct)

Edit A2 and include the "-" symbol in front of the number. Result = 170 (210 - 40 being incorrect). Repeat with another cell, say A6. Result = 90 (210 - 120 being incorrect)

I have checked the cell formatting and used "Value Highlight" to ensure that they are all numerical values. All cells are numbers and A7 is highlighted as a formula.

Any Ideas?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by DEBCal
close date 2020-01-20 13:51:48.243808

Comments

2

Errrr... how "210 - 40 being incorrect"???? You stopped adding +20 to your sum - and also you now subtract 20 from your sum, 170 being the correct result. Try doing on paper:

10 + (-20) + 30 + 40 + 50 + 60
Mike Kaganski gravatar imageMike Kaganski ( 2020-01-17 14:11:07 +0100 )edit

Please change all uppercase title - it's considered yelling.

Opaque gravatar imageOpaque ( 2020-01-17 14:12:16 +0100 )edit

I just edited the post to make it more legible (indenting with 4 spaces to preserve the listing).

erAck gravatar imageerAck ( 2020-01-17 15:19:44 +0100 )edit

Yelling out.

ebot gravatar imageebot ( 2020-01-17 15:51:14 +0100 )edit

@DEBCal - Counterquestion: What's the difference(!) of +20 and -20?

Opaque gravatar imageOpaque ( 2020-01-17 16:52:28 +0100 )edit

HI All. Sincere apologies, I did later "do it on paper"and realised my mistake. Was supposed to have returned here to delete my question but the weekend happened. Apologies again and thanks for your responses.

DEBCal gravatar imageDEBCal ( 2020-01-20 13:51:25 +0100 )edit