How to calculate an absolute value in LibreOffice Calc?

Question

Dear friends,My question is multiple...1) Absolute value for a negative number in a single cell. I notice that the supposed formula does NOT always work on the same spreadsheet. It is the formula =ABS(-56).2) How can I obtain the absolute value of the sum of several cells (with opposite signs) without having to copy the cell references one by one, as the formula does not seem to work if one selects multiple cells, a range written with a colon like A4:A15...How should I do to get a sum in absolute value from cells containing formulas and from which I only wish to use the value, the result.Thank you for any guidance you can provide.

Pierr10 · Answer

Hello,  I don't understand what the problem is with the first question (and I don't really see the point)  For the second question, simply type =ABS(SUM(C5:D8)) to get the absolute value of the sum of the numbers contained in the range C5:D8 (for example) It should work in all cases regardless of the content of the cells.

yclik · Answer

Good evening a proposal if understood correctly

y3x · Answer

Hello, Help Menu and LibreOffice Help.  Click on the Index tab and type "Absolute values" in the search field and press the "Enter" key on the keyboard.  Click 2 times on "absolute" below the search field. You will see the help results on the right.  You can add this help to the bookmarks by clicking on the "Add to bookmarks" icon in the toolbar.  -- "To achieve any change in our lives, we must start by expressing gratitude for what we already have."

Raymond PENTIER · Answer

Hello Hannibal. For your question 1, the formula you mentioned will definitely work; what might not work is if you wrote =ABS(A1) and A1 contained not the negative number -56 but the text "-56" ... For your question 2, it lacks clarity and can be interpreted differently. Indeed, you wrote two opposing things: How to obtain the absolute value of the sum of several cells ... -> It's the formula from Pïerr10 that applies. How to get an absolute sum from cells containing formulas and for which I only want to use the value, the result. -> It's the formula from yclik that applies.  Retirement is great! Especially in the Antilles... Raymond (INSA, AFPA)

How to calculate an absolute value in LibreOffice Calc?

4 réponses

Texture issues in enshrouded

Edit ad on leboncoin for free

Disable hard drive password

Duration of unpaid filing with telephone operators

Where to rewatch temptation island...

Black screen at wakfu launch

My pc starts up correctly but my screen won't turn on: what should i do?

Voicemail icon that remains displayed

Is onfancy.fr reliable?

Is the sports shoes website reliable?