[da-dansk] Re: Nye regnearksfunktioner

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 <leiflodahl@gmail.com>:

> 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+unsubscribe@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