De er nu lagt ind fsva. GUI'en. Jeg har desuden forslag om at RAWSUBTRACT -> RÅFRATRÆK.
/Leif 2016-05-23 12:45 GMT+02:00 Leif Lodahl <[email protected]>: > 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 [email protected] 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
