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

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 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

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

( 2020-01-17 14:11:07 +0100 )edit

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

( 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).

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

Yelling out.

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

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

( 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.

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