Numeric/absolute values in spreadsheets
Improving code-fu by using REAL intelligence since 2016
The function for numeric value (absolute value)
If you need to get the numeric value of a number or expression, this is done with ABS() in both Excel and Calc.
For Microsoft Excel it looks like this:
For OpenOffice Calc it looks like this:
For Microsoft Excel it looks like this:
For OpenOffice Calc it looks like this:
Excel function names in various languages
For some reason Microsoft has decided to have localized function names, so for non-English versions of Excel, you need to use the translated function names. This is as far as I have gotten, finding the localized function names for this chapter:
| Catalan | ABS() |
| Czech | ABS() |
| Danish | ABS() |
| Dutch | ABS() |
| English | ABS() |
| Finnish | ITSEISARVO() |
| French | ABS() |
| Galician | ABS() |
| German | ABS() |
| Hungarian | ABS() |
| Italian | ABS() |
| Norwegian | ABS() |
| Polish | MODUŁ.LICZBY() |
| Portuguese (BR) | ABS() |
| Portuguese (PT) | ABS() |
| Russian | ABS() |
| Spanish | ABS() |
| Swedish | ABS() |
| Turkish | MUTLAK() |