Ark1
| Excel funtions |
|
|
|
|
|
|
|
| English name |
"da" name (Danish) |
"de" name (German) |
"no" name (Norwegian) |
| COUNT |
TÆL |
ANZAHL |
ANTALL
|
| IF |
HVIS |
WENN |
HVIS
|
| ISNA |
|
|
ERIT
|
| ISERROR |
ER.FEJL |
|
ERFEIL
|
| SUM |
SUM |
SUMME |
SUMMER
|
| AVERAGE |
MIDDEL |
MITTELWERT |
GJENNOMSNITT
|
| MIN |
MIN |
MIN |
MIN
|
| MAX |
MAKS |
MAX |
STØRST
|
| ROW |
RÆKKE |
ZEILE |
RAD
|
| COLUMN |
KOLONNE |
SPALTE |
KOLONNE
|
| NA |
|
|
IT
|
| NPV |
|
|
|
| STDEV |
|
|
|
| DOLLAR |
|
DM |
|
| FIXED |
|
FEST |
|
| SIN |
SIN |
SIN |
|
| COS |
COS |
COS |
|
| TAN |
TAN |
TAN |
|
| ATAN |
|
ARCTAN |
|
| PI |
PI |
PI |
|
| SQRT |
|
WURZEL |
|
| EXP |
EKSP |
EXP |
|
| LN |
LN |
LN |
|
| LOG10 |
LOG10 |
LOG10 |
|
| ABS |
|
ABS |
|
| INT |
|
|
|
| SIGN |
|
VORZEICHEN |
|
| ROUND |
RUND.OP |
RUNDEN |
|
| LOOKUP |
SLÅ.OP |
|
|
| INDEX |
INDEKS |
INDEX |
|
| REPT |
|
|
|
| MID |
|
|
|
| LEN |
LÆNGDE |
L¨ANGE |
|
| VALUE |
VÆRDI |
WERT |
|
| TRUE |
SANDT |
WAHR |
|
| FALSE |
FALSK |
FALSCH |
|
| AND |
OG |
UND |
|
| OR |
ELLER |
ODER |
|
| NOT |
IKKE |
NICHT |
|
| MOD |
|
|
|
| DCOUNT |
|
|
|
| DSUM |
|
|
|
| DAVERAGE |
DMIDDEL |
DBMITTELWERT |
|
| DMIN |
DMIN |
DBMIN |
|
| DMAX |
DMAX |
DBMAX |
|
| DSTDEV |
|
|
|
| VAR |
VARIANS |
VARIANZ |
|
| DVAR |
DVARIANS |
DBVARIANZ |
|
| TEXT |
TEKST |
TEXT |
|
| LINEST |
|
|
|
| TREND |
|
|
|
| LOGEST |
|
|
|
| GROWTH |
|
|
|
| GOTO |
|
|
|
| UnknownFunction55 |
|
|
|
| HALT |
|
|
|
| PV |
|
|
|
| FV |
|
|
|
| NPER |
|
|
|
| PMT |
|
|
|
| RATE |
|
|
|
| MIRR |
|
|
|
| IRR |
|
|
|
| RAND |
|
|
|
| MATCH |
|
|
|
| DATE |
|
DATUM |
|
| TIME |
TID |
ZEIT |
|
| DAY |
DAG |
TAG |
|
| MONTH |
MÅNED |
MONAT |
|
| YEAR |
ÅR |
JAHR |
|
| WEEKDAY |
UGEDAG |
WOCHENTAG |
|
| HOUR |
TIME |
|
|
| MINUTE |
MINUT |
|
|
| SECOND |
SEKUND |
|
|
| NOW |
NU |
JETZT |
|
| AREAS |
OMRÅDER |
|
|
| ROWS |
RÆKKER |
|
|
| COLUMNS |
KOLONNER |
|
|
| OFFSET |
|
|
|
| ABSREF |
|
|
|
| RELREF |
|
|
|
| ARGUMENT |
ARGUMENT |
|
|
| SEARCH |
SØG |
|
|
| TRANSPOSE |
TRANSPONER |
|
|
| ERROR |
FEJL |
|
|
| STEP |
|
|
jpelsner@gmx.net. |
| TYPE |
VÆRDITYPE |
|
|
| ECHO |
|
|
|
| SETNAME |
|
|
|
| CALLER |
|
|
|
| DEREF |
|
|
|
| WINDOWS |
|
|
|
| SERIESSUM |
|
|
|
| DOCUMENTS |
|
|
|
| ACTIVECELL |
|
|
|
| SELECTION |
|
|
|
| RESULT |
RESULTAT |
|
|
| ATAN2 |
ARCTAN2 |
|
|
| ASIN |
ARCSIN |
|
|
| ACOS |
ARCCOS |
|
|
| CHOOSE |
VÆLG |
|
|
| HLOOKUP |
HOPSLAG |
|
|
| VLOOKUP |
VOPSLAG |
|
|
| LINKS |
|
|
|
| INPUT |
|
|
|
| ISREF |
|
|
|
| GETFORMULA |
|
|
|
| GETNAME |
|
|
|
| SETVALUE |
|
|
|
| LOG |
|
|
|
| EXEC |
|
|
|
| CHAR |
|
|
|
| LOWER |
|
|
|
| UPPER |
|
|
|
| PROPER |
|
|
|
| LEFT |
|
|
|
| RIGHT |
|
|
|
| EXACT |
|
|
|
| TRIM |
|
|
|
| REPLACE |
|
|
|
| SUBSTITUTE |
|
|
|
| CODE |
|
|
|
| NAMES |
|
|
|
| DIRECTORY |
|
|
|
| FIND |
|
|
|
| CELL |
|
|
|
| ISERR |
|
|
|
| ISTEXT |
|
|
|
| ISNUMBER |
|
|
|
| ISBLANK |
|
|
|
| T |
|
|
|
| N |
|
|
|
| FOPEN |
|
|
|
| FCLOSE |
|
|
|
| FSIZE |
|
|
|
| FREADLN |
|
|
|
| FREADLN |
|
|
|
| FWRITELN |
|
|
|
| FWRITELN |
|
|
|
| FPOS |
|
|
|
| DATEVALUE |
|
|
|
| TIMEVALUE |
|
|
|
| SLN |
|
|
|
| SYD |
|
|
|
| DDB |
|
|
|
| GETDEF |
|
|
|
| REFTEXT |
|
|
|
| TEXTREF |
|
|
|
| INDIRECT |
|
|
|
| REGISTER |
|
|
|
| CALLER |
|
|
|
| ADDBAR |
|
|
|
| ADDMENU |
|
|
|
| ADDCOMMAND |
|
|
|
| ENABLECOMMAND |
|
|
|
| CHECKCOMMAND |
|
|
|
| RENAMECOMMAND |
|
|
|
| SHOWBAR |
|
|
|
| DELETEMENU |
|
|
|
| DELETECOMMAND |
|
|
|
| GETCHARTITEM |
|
|
|
| DIALOGBOX |
|
|
|
| CLEAN |
|
|
|
| MDETERM |
|
|
|
| MINVERSE |
|
|
|
| MMULT |
|
|
|
| FILES |
|
|
|
| IPMT |
|
|
|
| PPMT |
|
|
|
| COUNTA |
|
|
|
| CANCELKEY |
|
|
|
| UnknownFunction171 |
|
|
|
| UnknownFunction172 |
|
|
|
| UnknownFunction173 |
|
|
|
| UnknownFunction174 |
|
|
|
| INITIATE |
|
|
|
| REQUEST |
|
|
|
| POKE |
|
|
|
| EXECUTE |
|
|
|
| TERMINATE |
|
|
|
| RESTART |
|
|
|
| HELP |
|
|
|
| GETBAR |
|
|
|
| PRODUCT |
|
|
|
| FACT |
|
|
|
| GETCELL |
|
|
|
| GETWORKSPACE |
|
|
|
| GETWINDOW |
|
|
|
| GETDOCUMENT |
|
|
|
| DPRODUCT |
|
|
|
| ISNONTEXT |
|
|
|
| GETNOTE |
|
|
|
| NOTE |
|
|
|
| STDEVP |
|
|
|
| VARP |
|
|
|
| DSTDEVP |
|
|
|
| DVARP |
|
|
|
| TRUNC |
|
|
|
| ISLOGICAL |
|
|
|
| DCOUNTA |
|
|
|
| DELETEBAR |
|
|
|
| UNREGISTER |
|
|
|
| UnknownFunction202 |
|
|
|
| UnknownFunction203 |
|
|
|
| USDOLLAR |
|
|
|
| FINDB |
|
|
|
| SEARCHB |
|
|
|
| REPLACEB |
|
|
|
| LEFTB |
|
|
|
| RIGHTB |
|
|
|
| MIDB |
|
|
|
| LENB |
|
|
|
| ROUNDUP |
|
|
|
| ROUNDDOWN |
|
|
|
| ASC |
|
|
|
| DBCS |
|
|
|
| RANK |
|
|
|
| UnknownFunction217 |
|
|
|
| UnknownFunction218 |
|
|
|
| ADDRESS |
|
|
|
| DAYS360 |
|
TAGE360 |
|
| TODAY |
|
HEUTE |
|
| VDB |
|
|
|
| UnknownFunction223 |
|
|
|
| UnknownFunction224 |
|
|
|
| UnknownFunction225 |
|
|
|
| UnknownFunction226 |
|
|
|
| MEDIAN |
|
|
|
| SUMPRODUCT |
|
|
|
| SINH |
|
|
|
| COSH |
|
|
|
| TANH |
|
|
|
| ASINH |
|
|
|
| ACOSH |
|
|
|
| ATANH |
|
|
|
| DGET |
|
|
|
| CREATEOBJECT |
|
|
|
| VOLATILE |
|
|
|
| LASTERROR |
|
|
|
| CUSTOMUNDO |
|
|
|
| CUSTOMREPEAT |
|
|
|
| FORMULACONVERT |
|
|
|
| GETLINKINFO |
|
|
|
| TEXTBOX |
|
|
|
| INFO |
|
|
|
| GROUP |
|
|
|
| GETOBJECT |
|
|
|
| DBCS |
|
|
|
| PAUSE |
|
|
|
| UnknownFunction249 |
|
|
|
| UnknownFunction250 |
|
|
|
| RESUME |
|
|
|
| FREQUENCY |
|
|
|
| ADDTOOLBAR |
|
|
|
| DELETETOOLBAR |
|
|
|
| MAGIC |
|
|
|
| RESETTOOLBAR |
|
|
|
| EVALUATE |
|
|
|
| GETTOOLBAR |
|
|
|
| GETTOOL |
|
|
|
| SPELLINGCHECK |
|
|
|
| ERROR.TYPE |
|
|
|
| APPTITLE |
|
|
|
| WINDOWTITLE |
|
|
|
| SAVETOOLBAR |
|
|
|
| ENABLETOOL |
|
|
|
| PRESSTOOL |
|
|
|
| REGISTERID |
|
|
|
| GETWORKBOOK |
|
|
|
| AVEDEV |
|
|
|
| BETADIST |
|
|
|
| GAMMALN |
|
|
|
| BETAINV |
|
|
|
| BINOMDIST |
|
|
|
| CHIDIST |
|
|
|
| CHIINV |
|
|
|
| COMBIN |
|
|
|
| CONFIDENCE |
|
|
|
| CRITBINOM |
|
|
|
| EVEN |
|
|
|
| EXPONDIST |
|
|
|
| FDIST |
|
|
|
| FINV |
|
|
|
| FISHER |
|
|
|
| FISHERINV |
|
|
|
| FLOOR |
|
|
|
| GAMMADIST |
|
|
|
| GAMMAINV |
|
|
|
| CEILING |
|
|
|
| HYPGEOMDIST |
|
|
|
| LOGNORMDIST |
|
|
|
| LOGINV |
|
|
|
| NEGBINOMDIST |
|
|
|
| NORMDIST |
|
|
|
| NORMSDIST |
|
|
|
| NORMINV |
|
|
|
| NORMSINV |
|
|
|
| STANDARDIZE |
|
|
|
| ODD |
|
|
|
| PERMUT |
|
|
|
| POISSON |
|
|
|
| TDIST |
|
|
|
| WEIBULL |
|
|
|
| SUMXMY2 |
|
|
|
| SUMX2MY2 |
|
|
|
| SUMX2PY2 |
|
|
|
| CHITEST |
|
|
|
| CORREL |
|
|
|
| COVAR |
|
|
|
| FORECAST |
|
|
|
| FTEST |
|
|
|
| INTERCEPT |
|
|
|
| PEARSON |
|
|
|
| RSQ |
|
|
|
| STEYX |
|
|
|
| SLOPE |
|
|
|
| TTEST |
|
|
|
| PROB |
|
|
|
| DEVSQ |
|
|
|
| GEOMEAN |
|
|
|
| HARMEAN |
|
|
|
| SUMSQ |
|
|
|
| KURT |
|
|
|
| SKEW |
|
|
|
| ZTEST |
|
|
|
| LARGE |
|
|
|
| SMALL |
|
|
|
| QUARTILE |
|
|
|
| PERCENTILE |
|
|
|
| PERCENTRANK |
|
|
|
| MODE |
|
|
|
| TRIMMEAN |
|
|
|
| TINV |
|
|
|
| UnknownFunction333 |
|
|
|
| MOVIECOMMAND |
|
|
|
| GETMOVIE |
|
|
|
| CONCATENATE |
|
|
|
| POWER |
|
|
|
| PIVOTADDDATA |
|
|
|
| GETPIVOTTABLE |
|
|
|
| GETPIVOTFIELD |
|
|
|
| GETPIVOTITEM |
|
|
|
| RADIANS |
|
|
|
| DEGREES |
|
|
|
| SUBTOTAL |
|
|
|
| SUMIF |
|
|
|
| COUNTIF |
|
|
|
| COUNTBLANK |
|
|
|
| SCENARIOGET |
|
|
|
| OPTIONSLISTSGET |
|
|
|
| ISPMT |
|
|
|
| DATEDIF |
|
|
|
| DATESTRING |
|
|
|
| NUMBERSTRING |
|
|
|
| ROMAN |
|
|
|
| OPENDIALOG |
|
|
|
| SAVEDIALOG |
|
|
|
| VIEWGET |
|
|
|
| GETPIVOTDATA |
|
|
|
| HYPERLINK |
|
|
|
| PHONETIC |
|
|
|
| AVERAGEA |
|
|
|
| MAXA |
|
|
|
| MINA |
|
|
|
| STDEVPA |
|
|
|
| VARPA |
|
|
|
| STDEVA |
|
|
|
| VARA |
|
|
|