Ask Your Question

How I do to calculate percentages on LibreOffice?

asked 2019-05-04 23:49:10 +0200

RochTristan gravatar image


When I used Excel, I knew that I had to make =(value+value) to add numbers and percentages. The problem is that when I do it for LibreOffice calc, it seems that the result gives "VALUE!",

I recommend you to check the image that I sent so that you could better understand my problem,

Thanks you to answer me!

C:\fakepath\Screenshot from 2019-05-04 17-41-49.png

edit retag flag offensive close merge delete


What's the point of the brackets? Try mere =E2 + F2 instead.

gabix gravatar imagegabix ( 2019-05-05 00:56:24 +0200 )edit

I just tried it, but it displays the same thing. I don't understand that this is so different from Excel. Probably that I should learn to use further Calc and probably that I could find the solution.

RochTristan gravatar imageRochTristan ( 2019-05-05 01:08:11 +0200 )edit

Share the file.

gabix gravatar imagegabix ( 2019-05-05 01:18:22 +0200 )edit

I solved my issue. It was because I added a "," instead of "." to my numbers.

C:\fakepath\Screenshot from 2019-05-04 19-22-09.png

RochTristan gravatar imageRochTristan ( 2019-05-05 01:23:31 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-05-05 19:27:34 +0200

newbie-02 gravatar image

you already answered your question,

just to have it in an answer instead of a comment:

while you are using an english? 'locale', input like 8.35% with a 'point' is evaluated as a number, while 8,35% with a 'comma' instead is interpreted as text.

it's the other way around in most other - european - locale settings.



edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-05-04 23:49:10 +0200

Seen: 77 times

Last updated: May 05