Hej alle,
Jeg har undersøgt lidt om de nye regnearksfunktioner, og er kommet frem til
hvad de tilsvarende funktioner hedder i Excel:
CONCAT an enhanced version of CONCATENATE, allowing ranges, columns and
references as arguments tdf#97831 (Winfried Donkers)
The function is compatible with MS Excel 2016 function CONCAT.
Dansk:SAMMENKÆD
TEXTJOIN to concatenate strings with delimeters between the strings.
tdf#97831 (Winfried Donkers)
TEXTJOIN allows the same string arguments as CONCAT and has a string
argument that will be used as delimiter between the strings to be joined.
Also, it is possible to opt for empty cells to be skipped.
The function is compatible with MS Excel 2016 function TEXTJOIN.
Dansk:TEKST.KOMBINER
IFS a cascaded IF-function tdf#97831 (Winfried Donkers)
IFS works like if A then B else if C then D else if (etc.).
The function is compatible with MS Excel 2016 function IFS.
Dansk:HVISER
SWITCH a multiple choice selection function tdf#97831 (Winfried Donkers)
SWITCH compares one expression with 1 to n possible values and
returns the result belonging to the first values that equals expression.
The function is compatible with MS Excel 2016 function SWITCH.
Dansk:SKIFT
MINIFS, MAXIFS tdf#97831 (Winfried Donkers)
These statistical functions work like SUMIFS and AVERAGEIFS, but
return the minimum respectively maximum value of the resulting range.
The functions are compatible with MS Excel 2016 functions MINIFS and MAXIFS.
Dansk:MAKSHVISER
Dansk:MINHVISER
Kilde:
https://support.office.com/da-dk/article/Nyheder-i-Excel-2016-til-Windows-5fdb9208-ff33-45b6-9e08-1f5cdb3a6c73?ui=da-DK&rs=da-DK&ad=DK
/Leif
--
Send en e-mail til dansk+unsubscr...@da.libreoffice.org for instruktioner om
hvordan du ophæver dit abonnement
Problemer? http://da.libreoffice.org/kontakt-os/postlister/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
Listens arkiv er tilgængelig på http://listarchives.libreoffice.org/da/dansk/
Alle beskeder du sender til listen bliver publiseret her og kan ikke
efterfølgende slettes
