__ __ __ __ _____ _ _ _____ _ _ _ | \/ | \ \ / / | __ \ (_) | | / ____| | | | | | \ / |_ __\ V / | |__) | __ ___ ____ _| |_ ___ | (___ | |__ ___| | | | |\/| | '__|> < | ___/ '__| \ \ / / _` | __/ _ \ \___ \| '_ \ / _ \ | | | | | | |_ / . \ | | | | | |\ V / (_| | || __/ ____) | | | | __/ | | |_| |_|_(_)_/ \_\ |_| |_| |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1 if you need WebShell for Seo everyday contact me on Telegram Telegram Address : @jackleetFor_More_Tools:
<!DOCTYPE html>
<html lang="es" dir="ltr">
<head>
<base href="../../../../">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Funciones add-in, lista de funciones de análisis, segunda parte</title>
<link rel="shortcut icon" href="media/navigation/favicon.ico">
<link type="text/css" href="normalize.css" rel="Stylesheet">
<link type="text/css" href="prism.css" rel="Stylesheet">
<link type="text/css" href="default.css" rel="Stylesheet">
<script type="text/javascript" src="polyfills.js"></script><script type="text/javascript" src="languages.js"></script><script type="text/javascript" src="es/langnames.js"></script><script type="text/javascript" src="flexsearch.debug.js"></script><script type="text/javascript" src="prism.js"></script><script type="text/javascript" src="help2.js" defer></script><script type="text/javascript" src="a11y-toggle.js" defer></script><script type="text/javascript" src="paginathing.js" defer></script><script type="text/javascript" src="es/bookmarks.js" defer></script><script type="text/javascript" src="es/contents.js" defer></script><script type="text/javascript" src="help.js" defer></script><meta name="viewport" content="width=device-width,initial-scale=1">
</head>
<body>
<header id="TopLeftHeader"><a class="symbol" href="es/text/shared/05/new_help.html"><div></div></a><a class="logo" href="es/text/shared/05/new_help.html"><p dir="auto">Ayuda de LibreOffice 25.2</p></a><div class="dropdowns"><div class="modules">
<button type="button" data-a11y-toggle="modules-nav" id="modules" aria-haspopup="true" aria-expanded="false" aria-controls="modules-nav">Módulo</button><nav id="modules-nav" hidden=""></nav>
</div></div></header><aside class="leftside"><input id="accordion-1" name="accordion-menu" type="checkbox"><label for="accordion-1" dir="auto">Contenido</label><div id="Contents" class="contents-treeview"></div></aside><div id="SearchFrame"><div id="Bookmarks">
<input id="search-bar" type="search" class="search" placeholder="Buscar en los marcadores del módulo elegido" dir="auto"><div class="nav-container" tabindex="0"><nav class="index" dir="auto"></nav></div>
</div></div>
<div id="DisplayArea" itemprop="softwareHelp" itemscope="true" itemtype="http://schema.org/SoftwareApplication">
<noscript><div id="WarnJS"><h1 dir="auto">Active JavaScript en el navegador para mostrar las páginas de ayuda de LibreOffice.</h1></div></noscript>
<a id="bm_id3145074"></a><meta itemprop="keywords" content="números imaginarios en funciones de análisis"> <meta itemprop="keywords" content="números complejos en funciones de análisis">
<h1 id="hd_id3154659" dir="auto">
<a id="head_addin_analysis_two"></a>Funciones de complemento. Lista de funciones de análisis, parte 2</h1>
<div class="note">
<div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/note.svg" alt="note" style="width:40px;height:40px;"></div>
<div class="notetext"><p id="par_id961592361784406" dir="auto">Las funciones de complemento las proporciona el <a target="_top" href="es/text/sbasic/shared/calc_functions.html">servicio <span class="literal">com.sun.star.sheet.addin.Analysis</span> de UNO</a>.</p></div>
</div>
<br>
<a id="howtoget"></a><div class="howtoget">
<div><p class="howtogetheader" dir="auto"><a id="wie"></a>Para acceder a esta orden…</p></div>
<div class="howtogetbody">
<div class="embedded"><p class="embedded" dir="auto"><span class="emph">Insertar ▸ Función ▸</span> categoría <span class="emph">Complemento</span></p></div>
</div>
</div>
<br>
<a id="imcos"></a>
<h2 id="hd_id69271214320055" dir="auto"><a target="_top" href="es/text/scalc/01/func_imcos.html">IM.COS</a></h2>
<p id="par_id207971541015759" class="paragraph" dir="auto">Devuelve el coseno de un número complejo.</p>
<a id="imcosh"></a>
<h2 id="hd_id217971417131058" dir="auto"><a target="_top" href="es/text/scalc/01/func_imcosh.html">IM.COSH</a></h2>
<p id="par_id6527438118584" class="paragraph" dir="auto">Devuelve el coseno hiperbólico de un número complejo.</p>
<a id="imcot"></a>
<h2 id="hd_id7625634121212" dir="auto"><a target="_top" href="es/text/scalc/01/func_imcot.html">IM.COT</a></h2>
<p id="par_id13708154784779" class="paragraph" dir="auto">Devuelve la cotangente de un número complejo.</p>
<a id="imcsc"></a>
<h2 id="hd_id2907192866882" dir="auto"><a target="_top" href="es/text/scalc/01/func_imcsc.html">IM.CSC</a></h2>
<p id="par_id11614766524423" class="paragraph" dir="auto">Devuelve la cosecante de un número complejo.</p>
<a id="imcsch"></a>
<h2 id="hd_id2111268313694" dir="auto"><a target="_top" href="es/text/scalc/01/func_imcsch.html">IM.CSCH</a></h2>
<p id="par_id15108118182663" class="paragraph" dir="auto">Devuelve la cosecante hiperbólica de un número complejo.</p>
<a id="imcsec"></a>
<h2 id="hd_id882954222038" dir="auto"><a target="_top" href="es/text/scalc/01/func_imsec.html">IM.SEC</a></h2>
<p id="par_id25971292332203" class="paragraph" dir="auto">Devuelve la secante de un número complejo.</p>
<a id="imcsech"></a>
<h2 id="hd_id25480538323169" dir="auto"><a target="_top" href="es/text/scalc/01/func_imsech.html">IM.SECH</a></h2>
<p id="par_id295081583312989" class="paragraph" dir="auto">Devuelve la secante hiperbólica de un número complejo.</p>
<a id="imsin"></a>
<h2 id="hd_id14741462320337" dir="auto"><a target="_top" href="es/text/scalc/01/func_imsin.html">IM.SENO</a></h2>
<p id="par_id1856698528833" class="paragraph" dir="auto">Devuelve el seno de un número complejo.</p>
<a id="imsinh"></a>
<h2 id="hd_id12978120123414" dir="auto"><a target="_top" href="es/text/scalc/01/func_imsinh.html">IM.SENOH</a></h2>
<p id="par_id21086201967951" class="paragraph" dir="auto">Devuelve el seno hiperbólico de un número complejo.</p>
<a id="imtan"></a>
<h2 id="hd_id186491693515289" dir="auto"><a target="_top" href="es/text/scalc/01/func_imtan.html">IM.TAN</a></h2>
<p id="par_id184313129618659" class="paragraph" dir="auto">Devuelve la tangente de un número complejo.</p>
<a id="convert"></a>
<h2 id="hd_id14741462320147" dir="auto"><a target="_top" href="es/text/scalc/01/func_convert.html">CONVERTIR</a></h2>
<p id="par_id1856698528077" class="paragraph" dir="auto">
Convierte un valor de una unidad de medida al valor correspondiente en otra unidad de medida.
</p>
<a id="complexfunc"></a>
<a id="bm_id3154054"></a><meta itemprop="keywords" content="COMPLEJO">
<a id="bm_id3156116"></a>
<h2 id="hd_id3154054" dir="auto">COMPLEJO</h2>
<p id="par_id3156111" class="paragraph" dir="auto"><span class="avis">El resultado es un número complejo creado a partir de un coeficiente real y un coeficiente imaginario.</span></p>
<div class="embedded">
<a id="sectionsyntax"></a>
<h4 id="hd_id3152015" dir="auto">Sintaxis</h4>
</div>
<p id="par_id3155999" class="code" dir="auto">COMPLEJO(NúmeroReal; INum [; Sufijo])</p>
<p id="par_id3153626" class="paragraph" dir="auto"> <span class="emph">NúmeroReal</span> es el coeficiente real de un número complejo.</p>
<p id="par_id3149135" class="paragraph" dir="auto"> <span class="emph">INum</span> es el coeficiente imaginario de un número complejo.</p>
<p id="par_id3155849" class="paragraph" dir="auto"> <span class="emph">Sufijo</span> es una lista de opciones, "i" o "j".</p>
<div class="embedded">
<a id="sectionexample"></a>
<h4 id="hd_id281171" dir="auto">Ejemplo</h4>
</div>
<p id="par_id3143229" class="paragraph" dir="auto"> <span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=COMPLEJO(3;4;"j")</span> devuelve 3+4j.</p>
<a id="factdouble"></a>
<a id="bm_id3147096"></a><meta itemprop="keywords" content="FACT.DOBLE"> <meta itemprop="keywords" content="factoriales,números con incrementos de dos">
<a id="bm_id3150950"></a>
<h2 id="hd_id3147096" dir="auto">FACT.DOBLE</h2>
<p id="par_id3151309" class="paragraph" dir="auto"><span class="avis">El resultado es el factorial del número en incrementos de 2.</span></p>
<div class="embedded">
<a id="sectionsyntax"></a>
<h4 id="hd_id3152015" dir="auto">Sintaxis</h4>
</div>
<p id="par_id3155121" class="code" dir="auto">FACT.DOBLE(Número)</p>
<p id="par_id3158440" class="paragraph" dir="auto">Devuelve <span class="emph">Número</span> <span class="emph">!!</span>, el factorial doble de <span class="emph">Número</span>, donde <span class="emph">Número</span> es un número entero mayor o igual a cero.</p>
<p id="par_id2480849" class="paragraph" dir="auto">Para números pares FACT.DOBLE(n) devuelve:</p>
<p id="par_id4181951" class="paragraph" dir="auto">2*4*6*8* ... *n</p>
<p id="par_id2927335" class="paragraph" dir="auto">Para números impares FACT.DOBLE(n) devuelve:</p>
<p id="par_id2107303" class="paragraph" dir="auto">1*3*5*7* ... *n</p>
<p id="par_id4071779" class="paragraph" dir="auto">FACT.DOBLE(0) devuelve 1 por definición.</p>
<div class="embedded">
<a id="sectionexample"></a>
<h4 id="hd_id281171" dir="auto">Ejemplo</h4>
</div>
<p id="par_id7844477" class="paragraph" dir="auto"> <span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=FACT.DOBLE(5)</span> devuelve 15.</p>
<p id="par_id3154116" class="paragraph" dir="auto"> <span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=FACT.DOBLE(6)</span> devuelve 48.</p>
<p id="par_id6478469" class="paragraph" dir="auto"> <span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=FACT.DOBLE(0)</span> devuelve 1.</p>
<a id="imabs"></a>
<p id="par_id3145074" class="paragraph" dir="auto"></p>
<a id="bm_id3154959"></a><meta itemprop="keywords" content="IM.ABS">
<a id="bm_id3154541"></a>
<h2 id="hd_id3154959" dir="auto">IM.ABS</h2>
<p id="par_id3149895" class="paragraph" dir="auto"><span class="avis">El resultado es el valor absoluto de un número complejo.</span></p>
<div class="embedded">
<a id="sectionsyntax"></a>
<h4 id="hd_id3152015" dir="auto">Sintaxis</h4>
</div>
<p id="par_id3151302" class="code" dir="auto">IM.ABS("Número Complejo")</p>
<p id="par_id3153974" class="paragraph" dir="auto"><a id="complex"></a><span class="emph">NúmeroComplejo</span> es un número complejo que se introduce como "x+yi" o "x+yj". </p>
<div class="embedded">
<a id="sectionexample"></a>
<h4 id="hd_id281171" dir="auto">Ejemplo</h4>
</div>
<p id="par_id3143222" class="paragraph" dir="auto"> <span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=IM.ABS("5+12j")</span> devuelve 13.</p>
<a id="imargument"></a>
<a id="bm_id3148748"></a><meta itemprop="keywords" content="IM.ANGULO">
<a id="bm_id3147297"></a>
<h2 id="hd_id3148748" dir="auto">IM.ANGULO</h2>
<p id="par_id3151341" class="paragraph" dir="auto"><span class="avis">El resultado es el argumento (ángulo phi) de un número complejo.</span></p>
<div class="embedded">
<a id="sectionsyntax"></a>
<h4 id="hd_id3152015" dir="auto">Sintaxis</h4>
</div>
<p id="par_id3156402" class="code" dir="auto">IM.ÁNGULO("Número Complejo")</p>
<div class="embedded"><p class="embedded" dir="auto"><span class="emph">NúmeroComplejo</span> es un número complejo que se introduce como "x+yi" o "x+yj". </p></div>
<div class="embedded">
<a id="sectionexample"></a>
<h4 id="hd_id281171" dir="auto">Ejemplo</h4>
</div>
<p id="par_id3159125" class="paragraph" dir="auto"> <span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=IM.ÁNGULO("3+4j")</span> devuelve 0,927295.</p>
<a id="imconjugate"></a>
<a id="bm_id3149955"></a><meta itemprop="keywords" content="IM.CONJUGADA">
<a id="bm_id3152782"></a>
<h2 id="hd_id3149955" dir="auto">IM.CONJUGADA</h2>
<p id="par_id3155263" class="paragraph" dir="auto"><span class="avis">El resultado es el complemento complejo conjugado de un número complejo.</span></p>
<div class="embedded">
<a id="sectionsyntax"></a>
<h4 id="hd_id3152015" dir="auto">Sintaxis</h4>
</div>
<p id="par_id3153082" class="code" dir="auto">IM.CONJUGADA("Número Complejo")</p>
<div class="embedded"><p class="embedded" dir="auto"><span class="emph">NúmeroComplejo</span> es un número complejo que se introduce como "x+yi" o "x+yj". </p></div>
<div class="embedded">
<a id="sectionexample"></a>
<h4 id="hd_id281171" dir="auto">Ejemplo</h4>
</div>
<p id="par_id3149688" class="paragraph" dir="auto"> <span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=IM.CONJUGADA("1+j")</span> devuelve 1-j.</p>
<a id="imdiv"></a>
<a id="bm_id3150024"></a><meta itemprop="keywords" content="IM.DIV">
<a id="bm_id3154679"></a>
<h2 id="hd_id3150024" dir="auto">IM.DIV</h2>
<p id="par_id3145825" class="paragraph" dir="auto"><span class="avis">El resultado es la división de dos números complejos.</span></p>
<div class="embedded">
<a id="sectionsyntax"></a>
<h4 id="hd_id3152015" dir="auto">Sintaxis</h4>
</div>
<p id="par_id3146942" class="code" dir="auto">IM.DIV("Numerador"; "Denominador")</p>
<p id="par_id3150741" class="paragraph" dir="auto"> <span class="emph">Numerador</span>, <span class="emph">Denominador</span> son números complejos que se especifican con el formato "x+yi" o "x+yj".</p>
<div class="embedded">
<a id="sectionexample"></a>
<h4 id="hd_id281171" dir="auto">Ejemplo</h4>
</div>
<p id="par_id3148440" class="paragraph" dir="auto"> <span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=IM.DIV("-238+240i";"10+24i")</span> devuelve 5+12i.</p>
<a id="imexp"></a>
<a id="bm_id3153039"></a><meta itemprop="keywords" content="IM.EXP">
<a id="bm_id3147468"></a>
<h2 id="hd_id3153039" dir="auto">IM.EXP</h2>
<p id="par_id3144741" class="paragraph" dir="auto"><span class="avis">El resultado es la potencia de e y el número complejo.</span> La constante e tiene un valor aproximado de 2,71828182845904.</p>
<div class="embedded">
<a id="sectionsyntax"></a>
<h4 id="hd_id3152015" dir="auto">Sintaxis</h4>
</div>
<p id="par_id3154810" class="code" dir="auto">IM.EXP("Número Complejo")</p>
<div class="embedded"><p class="embedded" dir="auto"><span class="emph">NúmeroComplejo</span> es un número complejo que se introduce como "x+yi" o "x+yj". </p></div>
<div class="embedded">
<a id="sectionexample"></a>
<h4 id="hd_id281171" dir="auto">Ejemplo</h4>
</div>
<p id="par_id3149253" class="paragraph" dir="auto"> <span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=IM.EXP("1+j") </span>devuelve 1,47+2,29j (redondeado).</p>
<a id="imln"></a>
<a id="bm_id3150898"></a><meta itemprop="keywords" content="IM.LN">
<a id="bm_id3149190"></a>
<h2 id="hd_id3150898" dir="auto">IM.LN</h2>
<p id="par_id3146853" class="paragraph" dir="auto"><span class="avis">El resultado es el logaritmo natural (en base e) de un número complejo.</span> La constante e tiene un valor aproximado de 2,71828182845904.</p>
<div class="embedded">
<a id="sectionsyntax"></a>
<h4 id="hd_id3152015" dir="auto">Sintaxis</h4>
</div>
<p id="par_id3155954" class="code" dir="auto">IM.LN("Número Complejo")</p>
<div class="embedded"><p class="embedded" dir="auto"><span class="emph">NúmeroComplejo</span> es un número complejo que se introduce como "x+yi" o "x+yj". </p></div>
<div class="embedded">
<a id="sectionexample"></a>
<h4 id="hd_id281171" dir="auto">Ejemplo</h4>
</div>
<p id="par_id3153736" class="paragraph" dir="auto"> <span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=IM.LN("1+j") </span>devuelve 0,35+0,79j (redondeado).</p>
<a id="imlog10"></a>
<a id="bm_id3155929"></a><meta itemprop="keywords" content="IM.LOG10">
<a id="bm_id3148765"></a>
<h2 id="hd_id3155929" dir="auto">IM.LOG10</h2>
<p id="par_id3149882" class="paragraph" dir="auto"><span class="avis">El resultado es el logaritmo común (en base 10) de un número complejo.</span></p>
<div class="embedded">
<a id="sectionsyntax"></a>
<h4 id="hd_id3152015" dir="auto">Sintaxis</h4>
</div>
<p id="par_id3150128" class="code" dir="auto">IM.LOG10("Número Complejo")</p>
<div class="embedded"><p class="embedded" dir="auto"><span class="emph">NúmeroComplejo</span> es un número complejo que se introduce como "x+yi" o "x+yj". </p></div>
<div class="embedded">
<a id="sectionexample"></a>
<h4 id="hd_id281171" dir="auto">Ejemplo</h4>
</div>
<p id="par_id3151021" class="paragraph" dir="auto"> <span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=IM.LOG10("1+j")</span> devuelve 0,15+0,34j (redondeado).</p>
<a id="imlog2"></a>
<a id="bm_id3155623"></a><meta itemprop="keywords" content="IM.LOG2">
<a id="bm_id3157975"></a>
<h2 id="hd_id3155623" dir="auto">IM.LOG2</h2>
<p id="par_id3150932" class="paragraph" dir="auto"><span class="avis">El resultado es el logaritmo binario de un número complejo.</span></p>
<div class="embedded">
<a id="sectionsyntax"></a>
<h4 id="hd_id3152015" dir="auto">Sintaxis</h4>
</div>
<p id="par_id3145355" class="code" dir="auto">IM.LOG2("Número Complejo")</p>
<div class="embedded"><p class="embedded" dir="auto"><span class="emph">NúmeroComplejo</span> es un número complejo que se introduce como "x+yi" o "x+yj". </p></div>
<div class="embedded">
<a id="sectionexample"></a>
<h4 id="hd_id281171" dir="auto">Ejemplo</h4>
</div>
<p id="par_id3149536" class="paragraph" dir="auto"> <span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=IM.LOG2("1+j")</span> devuelve 0,50+1,13j (redondeado).</p>
<a id="impower"></a>
<a id="bm_id3146106"></a><meta itemprop="keywords" content="IM.POT">
<a id="bm_id3155755"></a>
<h2 id="hd_id3146106" dir="auto">IM.POT</h2>
<p id="par_id3147245" class="paragraph" dir="auto"><span class="avis">El resultado es el <span class="emph">NúmeroComplejo</span> elevado a la potencia de <span class="emph">Número</span>.</span></p>
<div class="embedded">
<a id="sectionsyntax"></a>
<h4 id="hd_id3152015" dir="auto">Sintaxis</h4>
</div>
<p id="par_id3147501" class="code" dir="auto">IM.POT("Número Complejo"; Número)</p>
<div class="embedded"><p class="embedded" dir="auto"><span class="emph">NúmeroComplejo</span> es un número complejo que se introduce como "x+yi" o "x+yj". </p></div>
<p id="par_id3155743" class="paragraph" dir="auto"> <span class="emph">Número</span> es el exponente.</p>
<div class="embedded">
<a id="sectionexample"></a>
<h4 id="hd_id281171" dir="auto">Ejemplo</h4>
</div>
<p id="par_id3151393" class="paragraph" dir="auto"> <span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=IM.POT("2+3i";2)</span> devuelve -5+12i.</p>
<a id="improduct"></a>
<a id="bm_id3145626"></a><meta itemprop="keywords" content="IM.PRODUCT">
<a id="bm_id3150661"></a>
<h2 id="hd_id3145626" dir="auto">IM.PRODUCT</h2>
<p id="par_id3153545" class="paragraph" dir="auto"><span class="avis">El resultado es el producto de un conjunto de números complejos.</span></p>
<div class="embedded">
<a id="sectionsyntax"></a>
<h4 id="hd_id3152015" dir="auto">Sintaxis</h4>
</div>
<p id="par_id3149027" class="code" dir="auto">IM.PRODUCT(Complejo 1 [; Complejo 2 [; ... [; Complejo 255]])</p>
<div class="embedded">
<a id="complex255"></a>
<p id="par_id931584335947010" class="paragraph" dir="auto"><span class="emph">Complex 1; Complex 2; … ; Complex 255</span> are complex numbers, references to cells or to cell ranges of complex numbers. Complex numbers are entered in the form "x+yi" or "x+yj".</p>
</div>
<div class="embedded">
<a id="sectionexample"></a>
<h4 id="hd_id281171" dir="auto">Ejemplo</h4>
</div>
<p id="par_id3155815" class="paragraph" dir="auto"> <span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=IM.PRODUCT("3+4j";"5-3j")</span> devuelve 27+11j.</p>
<a id="imsqrt"></a>
<a id="bm_id3147570"></a><meta itemprop="keywords" content="IM.RAIZ2">
<a id="bm_id3151189"></a>
<h2 id="hd_id3147570" dir="auto">IM.RAIZ2</h2>
<p id="par_id3156131" class="paragraph" dir="auto"><span class="avis">El resultado es la raíz cuadrada de un número complejo.</span></p>
<div class="embedded">
<a id="sectionsyntax"></a>
<h4 id="hd_id3152015" dir="auto">Sintaxis</h4>
</div>
<p id="par_id3150760" class="code" dir="auto">IM.RAIZ2("Número Complejo")</p>
<div class="embedded"><p class="embedded" dir="auto"><span class="emph">NúmeroComplejo</span> es un número complejo que se introduce como "x+yi" o "x+yj". </p></div>
<div class="embedded">
<a id="sectionexample"></a>
<h4 id="hd_id281171" dir="auto">Ejemplo</h4>
</div>
<p id="par_id3152807" class="paragraph" dir="auto"> <span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=IM.RAIZ2("3+4i")</span> devuelve 2+1i.</p>
<a id="imreal"></a>
<a id="bm_id3147539"></a><meta itemprop="keywords" content="IM.REAL">
<a id="bm_id3148596"></a>
<h2 id="hd_id3147539" dir="auto">IM.REAL</h2>
<p id="par_id3155372" class="paragraph" dir="auto"><span class="avis">El resultado es el coeficiente real de un número complejo.</span></p>
<div class="embedded">
<a id="sectionsyntax"></a>
<h4 id="hd_id3152015" dir="auto">Sintaxis</h4>
</div>
<p id="par_id3153927" class="code" dir="auto">IM.REAL("Número Complejo")</p>
<div class="embedded"><p class="embedded" dir="auto"><span class="emph">NúmeroComplejo</span> es un número complejo que se introduce como "x+yi" o "x+yj". </p></div>
<div class="embedded">
<a id="sectionexample"></a>
<h4 id="hd_id281171" dir="auto">Ejemplo</h4>
</div>
<p id="par_id3155986" class="paragraph" dir="auto"> <span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=IM.REAL("1+3j")</span> devuelve 1.</p>
<a id="imsum"></a>
<a id="bm_id3156312"></a><meta itemprop="keywords" content="IM.SUM">
<a id="bm_id3149454"></a>
<h2 id="hd_id3156312" dir="auto">IM.SUM</h2>
<p id="par_id3153215" class="paragraph" dir="auto"><span class="avis">El resultado es la suma de un conjunto de números complejos.</span></p>
<div class="embedded">
<a id="sectionsyntax"></a>
<h4 id="hd_id3152015" dir="auto">Sintaxis</h4>
</div>
<p id="par_id3152930" class="code" dir="auto">IM.SUM(Complejo 1 [; Complejo 2 [; ... [; Complejo 255]])</p>
<div class="embedded">
<a id="complex255"></a>
<p id="par_id931584335947010" class="paragraph" dir="auto"><span class="emph">Complex 1; Complex 2; … ; Complex 255</span> are complex numbers, references to cells or to cell ranges of complex numbers. Complex numbers are entered in the form "x+yi" or "x+yj".</p>
</div>
<div class="embedded">
<a id="sectionexample"></a>
<h4 id="hd_id281171" dir="auto">Ejemplo</h4>
</div>
<p id="par_id3147081" class="paragraph" dir="auto"> <span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=IM.SUM("13+4j";"5+3j")</span> devuelve 18+7j.</p>
<a id="imsub"></a>
<a id="bm_id3163826"></a><meta itemprop="keywords" content="IM.SUSTR">
<a id="bm_id3152481"></a>
<h2 id="hd_id3163826" dir="auto">IM.SUSTR</h2>
<p id="par_id3149277" class="paragraph" dir="auto"><span class="avis">El resultado es la sustracción de dos números complejos.</span></p>
<div class="embedded">
<a id="sectionsyntax"></a>
<h4 id="hd_id3152015" dir="auto">Sintaxis</h4>
</div>
<p id="par_id3149710" class="code" dir="auto">IM.SUSTR("Número Complejo1"; "Número Complejo2")</p>
<div class="embedded"><p class="embedded" dir="auto"><span class="emph">NúmeroComplejo</span> es un número complejo que se introduce como "x+yi" o "x+yj". </p></div>
<div class="embedded">
<a id="sectionexample"></a>
<h4 id="hd_id281171" dir="auto">Ejemplo</h4>
</div>
<p id="par_id3150963" class="paragraph" dir="auto"> <span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=IM.SUB("13+4j";"5+3j")</span> devuelve 8+7j.</p>
<a id="imaginary"></a>
<a id="bm_id3145357"></a><meta itemprop="keywords" content="IMAGINARIO">
<a id="bm_id3154651"></a>
<h2 id="hd_id3145357" dir="auto">IMAGINARIO</h2>
<p id="par_id3146965" class="paragraph" dir="auto"><span class="avis">El resultado es el coeficiente imaginario de un número complejo.</span></p>
<div class="embedded">
<a id="sectionsyntax"></a>
<h4 id="hd_id3152015" dir="auto">Sintaxis</h4>
</div>
<p id="par_id3155522" class="code" dir="auto">IMAGINARIO("Número Complejo")</p>
<div class="embedded"><p class="embedded" dir="auto"><span class="emph">NúmeroComplejo</span> es un número complejo que se introduce como "x+yi" o "x+yj". </p></div>
<div class="embedded">
<a id="sectionexample"></a>
<h4 id="hd_id281171" dir="auto">Ejemplo</h4>
</div>
<p id="par_id3155592" class="paragraph" dir="auto"> <span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=IMAGINARIO("4+3j")</span> devuelve 3.</p>
<a id="oct2bin"></a>
<a id="bm_id3155103"></a><meta itemprop="keywords" content="OCT.A.BIN"> <meta itemprop="keywords" content="convertir,números octales, en números binarios">
<a id="bm_id3149290"></a>
<h2 id="hd_id3155103" dir="auto">OCT.A.BIN</h2>
<p id="par_id3146898" class="paragraph" dir="auto"><span class="avis">El resultado es la cadena que representa el número en forma binaria (base-2) para la cadena numérica octal introducida.</span></p>
<div class="embedded">
<a id="sectionsyntax"></a>
<h4 id="hd_id3152015" dir="auto">Sintaxis</h4>
</div>
<p id="par_id3154303" class="code" dir="auto">OCT.A.BIN(Numero[; Sitios])</p>
<p id="par_id3156013" class="paragraph" dir="auto"> <span class="emph">Número</span> es una cadena que representa un número octal. Puede tener un máximo de 10 posiciones. El digito binario más significativo es el de signo, los siguientes dígitos binarios devuelven el valor. Los números negativos se introducen como complemento a dos.</p>
<p id="par_id3153984" class="paragraph" dir="auto"> <span class="emph">Cifras</span> es el número de espacios totales.</p>
<div class="embedded">
<a id="sectionexample"></a>
<h4 id="hd_id281171" dir="auto">Ejemplo</h4>
</div>
<p id="par_id3147260" class="paragraph" dir="auto"> <span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=OCT.A.BIN("3";3)</span> devuelve "011".</p>
<a id="oct2dec"></a>
<a id="bm_id3152791"></a><meta itemprop="keywords" content="OCT.A.DEC"> <meta itemprop="keywords" content="convertir,números octales, en números decimales">
<a id="bm_id3151168"></a>
<h2 id="hd_id3152791" dir="auto">OCT.A.DEC</h2>
<p id="par_id3149199" class="paragraph" dir="auto"><span class="avis">El resultado es el número de la cadena numérica octal introducida.</span></p>
<div class="embedded">
<a id="sectionsyntax"></a>
<h4 id="hd_id3152015" dir="auto">Sintaxis</h4>
</div>
<p id="par_id3153902" class="code" dir="auto">OCT.A.DEC(Número)</p>
<p id="par_id3155326" class="paragraph" dir="auto"> <span class="emph">Número</span> es una cadena que representa un número octal. Puede tener un máximo de 10 posiciones. El bit más significativo es el de signo, los siguientes bits devuelven el valor. Los números negativos se introducen como complemento a dos.</p>
<div class="embedded">
<a id="sectionexample"></a>
<h4 id="hd_id281171" dir="auto">Ejemplo</h4>
</div>
<p id="par_id3154930" class="paragraph" dir="auto"> <span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=OCT.A.DEC("144")</span> devuelve 100.</p>
<a id="oct2hex"></a>
<a id="bm_id3155391"></a><meta itemprop="keywords" content="OCT.A.HEX"> <meta itemprop="keywords" content="convertir,números octales, en números hexadecimales">
<a id="bm_id3149904"></a>
<h2 id="hd_id3155391" dir="auto">OCT.A.HEX</h2>
<p id="par_id3148831" class="paragraph" dir="auto"><span class="avis">El resultado es la cadena que representa el número en forma hexadecimal para la cadena de números octales introducida.</span></p>
<div class="embedded">
<a id="sectionsyntax"></a>
<h4 id="hd_id3152015" dir="auto">Sintaxis</h4>
</div>
<p id="par_id3150523" class="code" dir="auto">OCT.A.HEX(Numero [; Sitio])</p>
<p id="par_id3159162" class="paragraph" dir="auto"> <span class="emph">Número</span> es una cadena que representa un número octal. Puede tener un máximo de 10 posiciones. El bit más significativo es el de signo, los siguientes bits devuelven el valor. Los números negativos se introducen como complemento a dos.</p>
<p id="par_id3145420" class="paragraph" dir="auto"> <span class="emph">Cifras</span> es el número de espacios totales.</p>
<div class="embedded">
<a id="sectionexample"></a>
<h4 id="hd_id281171" dir="auto">Ejemplo</h4>
</div>
<p id="par_id3148802" class="paragraph" dir="auto"> <span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=OCT.A.HEX("144";4)</span> devuelve "0064".</p>
<a id="relatedtopics"></a><div class="relatedtopics">
<p class="related" itemprop="mentions" dir="auto"><a id="related"></a><span class="emph">Temas relacionados</span></p>
<div class="relatedbody" itemprop="mentions">
<p id="par_id3147072" class="paragraph" dir="auto"><a target="_top" href="es/text/scalc/01/04060111.html">Funciones de complementos</a></p>
<p id="par_id3148869" class="paragraph" dir="auto"><a target="_top" href="es/text/scalc/01/04060115.html">Funciones de complemento. Lista de funciones de análisis, parte 1</a></p>
<p id="par_id3151242" class="paragraph" dir="auto"><a target="_top" href="es/text/scalc/01/04060108.html">Funciones estadísticas</a></p>
<p id="par_id260920161704025898" class="paragraph" dir="auto"><a target="_top" href="es/text/scalc/01/04060100.html">Funciones por categoría</a></p>
</div>
</div>
</div>
<div id="DonationFrame"></div>
<footer><h2 style="text-align: center;"><a href="https://books.libreoffice.org" target="_blank">Libros de LibreOffice</a></h2>
<div class="noteicon" dir="auto" style="display:flex;justify-content:center;flex-wrap:wrap;row-gap:15px;">
<img src="media/navigation/libo-writer.svg" alt="Writer Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-calc.svg" alt="Calc Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-impress.svg" alt="Impress Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-draw.svg" alt="Draw Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-base.svg" alt="Base Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-math.svg" alt="Math Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-symbol-black.svg" alt="Getting Started Icon" style="width:60px;height:60px;">
</div>
<div id="DEBUG" class="debug">
<h3 class="bug">Help content debug info:</h3>
<p dir="auto">This page is: <a href="https://opengrok.libreoffice.org/xref/help/source/text/scalc/01/04060116.xhp" target="_blank">/text/scalc/01/04060116.xhp</a></p>
<p dir="auto">Title is: Funciones add-in, lista de funciones de análisis, segunda parte</p>
<p id="bm_module" dir="auto"></p>
<p id="bm_system" dir="auto"></p>
<p id="bm_HID" dir="auto"></p>
</div></footer>
</body>
</html>
| Name | Type | Size | Permission | Actions |
|---|---|---|---|---|
| 02110000.html | File | 15.01 KB | 0644 |
|
| 02120100.html | File | 15.22 KB | 0644 |
|
| 02140000.html | File | 8.61 KB | 0644 |
|
| 02140100.html | File | 5.82 KB | 0644 |
|
| 02140200.html | File | 5.36 KB | 0644 |
|
| 02140300.html | File | 5.34 KB | 0644 |
|
| 02140400.html | File | 5.36 KB | 0644 |
|
| 02140500.html | File | 7.47 KB | 0644 |
|
| 02140600.html | File | 11.4 KB | 0644 |
|
| 02140700.html | File | 15.08 KB | 0644 |
|
| 02150000.html | File | 8.98 KB | 0644 |
|
| 02160000.html | File | 9.58 KB | 0644 |
|
| 02170000.html | File | 6.17 KB | 0644 |
|
| 02180000.html | File | 7.52 KB | 0644 |
|
| 02190000.html | File | 5.06 KB | 0644 |
|
| 02190100.html | File | 5.23 KB | 0644 |
|
| 02190200.html | File | 5.36 KB | 0644 |
|
| 02200000.html | File | 3.83 KB | 0644 |
|
| 02210000.html | File | 6.42 KB | 0644 |
|
| 02220000.html | File | 5.46 KB | 0644 |
|
| 03070000.html | File | 6.75 KB | 0644 |
|
| 03080000.html | File | 7.86 KB | 0644 |
|
| 03090000.html | File | 6.58 KB | 0644 |
|
| 03100000.html | File | 7.02 KB | 0644 |
|
| 04010000.html | File | 5.67 KB | 0644 |
|
| 04010100.html | File | 5.82 KB | 0644 |
|
| 04010200.html | File | 5.86 KB | 0644 |
|
| 04020000.html | File | 8.72 KB | 0644 |
|
| 04030000.html | File | 6.69 KB | 0644 |
|
| 04040000.html | File | 6.88 KB | 0644 |
|
| 04050000.html | File | 8.82 KB | 0644 |
|
| 04050100.html | File | 6.46 KB | 0644 |
|
| 04060000.html | File | 17.69 KB | 0644 |
|
| 04060100.html | File | 7.6 KB | 0644 |
|
| 04060101.html | File | 92.45 KB | 0644 |
|
| 04060102.html | File | 16.35 KB | 0644 |
|
| 04060103.html | File | 73.88 KB | 0644 |
|
| 04060104.html | File | 58.8 KB | 0644 |
|
| 04060105.html | File | 25.5 KB | 0644 |
|
| 04060106.html | File | 114.69 KB | 0644 |
|
| 04060107.html | File | 88.93 KB | 0644 |
|
| 04060108.html | File | 9.29 KB | 0644 |
|
| 04060109.html | File | 90.86 KB | 0644 |
|
| 04060110.html | File | 27.9 KB | 0644 |
|
| 04060111.html | File | 27.19 KB | 0644 |
|
| 04060112.html | File | 39.33 KB | 0644 |
|
| 04060115.html | File | 31.23 KB | 0644 |
|
| 04060116.html | File | 32.39 KB | 0644 |
|
| 04060118.html | File | 70.86 KB | 0644 |
|
| 04060119.html | File | 69.42 KB | 0644 |
|
| 04060120.html | File | 11.5 KB | 0644 |
|
| 04060181.html | File | 73.46 KB | 0644 |
|
| 04060182.html | File | 53.23 KB | 0644 |
|
| 04060183.html | File | 32.85 KB | 0644 |
|
| 04060184.html | File | 73.4 KB | 0644 |
|
| 04060185.html | File | 86.6 KB | 0644 |
|
| 04060199.html | File | 22.62 KB | 0644 |
|
| 04070000.html | File | 6.6 KB | 0644 |
|
| 04070100.html | File | 11.97 KB | 0644 |
|
| 04070200.html | File | 6.49 KB | 0644 |
|
| 04070300.html | File | 6.52 KB | 0644 |
|
| 04070400.html | File | 11.24 KB | 0644 |
|
| 04080000.html | File | 8.23 KB | 0644 |
|
| 04090000.html | File | 7.6 KB | 0644 |
|
| 05020000.html | File | 9.9 KB | 0644 |
|
| 05020600.html | File | 5.66 KB | 0644 |
|
| 05030000.html | File | 6.54 KB | 0644 |
|
| 05030300.html | File | 7.95 KB | 0644 |
|
| 05030400.html | File | 7.88 KB | 0644 |
|
| 05040000.html | File | 6.1 KB | 0644 |
|
| 05050100.html | File | 8.08 KB | 0644 |
|
| 05050300.html | File | 7.06 KB | 0644 |
|
| 05060000.html | File | 10.1 KB | 0644 |
|
| 05070000.html | File | 11.12 KB | 0644 |
|
| 05070500.html | File | 11.38 KB | 0644 |
|
| 05080000.html | File | 7.02 KB | 0644 |
|
| 05080100.html | File | 5.51 KB | 0644 |
|
| 05080200.html | File | 5.47 KB | 0644 |
|
| 05080300.html | File | 14.18 KB | 0644 |
|
| 05080400.html | File | 5.48 KB | 0644 |
|
| 05120000.html | File | 13.6 KB | 0644 |
|
| 05120100.html | File | 21.06 KB | 0644 |
|
| 05120200.html | File | 4.96 KB | 0644 |
|
| 05120300.html | File | 8.32 KB | 0644 |
|
| 05120400.html | File | 37.45 KB | 0644 |
|
| 05120500.html | File | 6.2 KB | 0644 |
|
| 06020000.html | File | 6.76 KB | 0644 |
|
| 06030000.html | File | 9.52 KB | 0644 |
|
| 06030100.html | File | 7.29 KB | 0644 |
|
| 06030200.html | File | 6.47 KB | 0644 |
|
| 06030300.html | File | 7.19 KB | 0644 |
|
| 06030400.html | File | 6.41 KB | 0644 |
|
| 06030500.html | File | 6.2 KB | 0644 |
|
| 06030600.html | File | 6.13 KB | 0644 |
|
| 06030700.html | File | 6.59 KB | 0644 |
|
| 06030800.html | File | 6.65 KB | 0644 |
|
| 06030900.html | File | 6.32 KB | 0644 |
|
| 06031000.html | File | 6.28 KB | 0644 |
|
| 06040000.html | File | 8.51 KB | 0644 |
|
| 06050000.html | File | 8.79 KB | 0644 |
|
| 06060000.html | File | 6.66 KB | 0644 |
|
| 06060200.html | File | 7.88 KB | 0644 |
|
| 06070000.html | File | 5.51 KB | 0644 |
|
| 06080000.html | File | 8.48 KB | 0644 |
|
| 06130000.html | File | 7.74 KB | 0644 |
|
| 07080000.html | File | 7.05 KB | 0644 |
|
| 07090000.html | File | 6.47 KB | 0644 |
|
| 07090100.html | File | 5.89 KB | 0644 |
|
| 12010000.html | File | 12.29 KB | 0644 |
|
| 12020000.html | File | 6.25 KB | 0644 |
|
| 12030000.html | File | 6.9 KB | 0644 |
|
| 12030100.html | File | 11.82 KB | 0644 |
|
| 12030200.html | File | 11.19 KB | 0644 |
|
| 12040000.html | File | 6.41 KB | 0644 |
|
| 12040100.html | File | 11.27 KB | 0644 |
|
| 12040201.html | File | 9.67 KB | 0644 |
|
| 12040300.html | File | 14.61 KB | 0644 |
|
| 12040400.html | File | 5.23 KB | 0644 |
|
| 12040500.html | File | 5.89 KB | 0644 |
|
| 12050000.html | File | 7.65 KB | 0644 |
|
| 12050100.html | File | 6.12 KB | 0644 |
|
| 12050200.html | File | 8.12 KB | 0644 |
|
| 12060000.html | File | 8.46 KB | 0644 |
|
| 12070000.html | File | 9.58 KB | 0644 |
|
| 12070100.html | File | 5.06 KB | 0644 |
|
| 12080000.html | File | 7 KB | 0644 |
|
| 12080100.html | File | 6.16 KB | 0644 |
|
| 12080200.html | File | 6.53 KB | 0644 |
|
| 12080300.html | File | 7.12 KB | 0644 |
|
| 12080400.html | File | 6.51 KB | 0644 |
|
| 12080500.html | File | 8.2 KB | 0644 |
|
| 12080600.html | File | 4.77 KB | 0644 |
|
| 12080700.html | File | 5.02 KB | 0644 |
|
| 12090000.html | File | 7.41 KB | 0644 |
|
| 12090100.html | File | 9.3 KB | 0644 |
|
| 12090101.html | File | 6.11 KB | 0644 |
|
| 12090102.html | File | 13.21 KB | 0644 |
|
| 12090103.html | File | 7.55 KB | 0644 |
|
| 12090104.html | File | 5.53 KB | 0644 |
|
| 12090105.html | File | 12.58 KB | 0644 |
|
| 12090106.html | File | 8.52 KB | 0644 |
|
| 12090200.html | File | 8.03 KB | 0644 |
|
| 12090300.html | File | 7.63 KB | 0644 |
|
| 12090400.html | File | 6.12 KB | 0644 |
|
| 12100000.html | File | 5.91 KB | 0644 |
|
| 12120000.html | File | 7.49 KB | 0644 |
|
| 12120100.html | File | 14.13 KB | 0644 |
|
| 12120200.html | File | 6.51 KB | 0644 |
|
| 12120300.html | File | 10.14 KB | 0644 |
|
| Add.html | File | 4.41 KB | 0644 |
|
| DeleteAllNotes.html | File | 5.81 KB | 0644 |
|
| DeleteNote.html | File | 5.96 KB | 0644 |
|
| EditSelectMenu.html | File | 8.32 KB | 0644 |
|
| FieldMenu.html | File | 6.25 KB | 0644 |
|
| FormatSparklineMenu.html | File | 6.89 KB | 0644 |
|
| HandleDuplicateRecords.html | File | 5.57 KB | 0644 |
|
| HideNote.html | File | 5.69 KB | 0644 |
|
| InsertCurrentDate.html | File | 6.36 KB | 0644 |
|
| InsertCurrentTime.html | File | 6.36 KB | 0644 |
|
| JumpToNextTable.html | File | 5.01 KB | 0644 |
|
| JumpToNextTableSel.html | File | 5.15 KB | 0644 |
|
| JumpToPrevTable.html | File | 5.04 KB | 0644 |
|
| JumpToPrevTableSel.html | File | 5.16 KB | 0644 |
|
| ManageNames.html | File | 12.1 KB | 0644 |
|
| MergeCellsMenu.html | File | 5.8 KB | 0644 |
|
| NavigateMenu.html | File | 5.33 KB | 0644 |
|
| NormalViewMode.html | File | 5.89 KB | 0644 |
|
| ODFF.html | File | 4.38 KB | 0644 |
|
| SelectColumn.html | File | 6.35 KB | 0644 |
|
| SelectData.html | File | 6.96 KB | 0644 |
|
| SelectRow.html | File | 6.04 KB | 0644 |
|
| SelectUnprotectedCells.html | File | 5.15 KB | 0644 |
|
| SelectVisibleColumns.html | File | 5.34 KB | 0644 |
|
| SelectVisibleRows.html | File | 5.19 KB | 0644 |
|
| SetInputMode.html | File | 5.87 KB | 0644 |
|
| SheetCommentMenu.html | File | 6.04 KB | 0644 |
|
| ShowNote.html | File | 5.68 KB | 0644 |
|
| TableSelectAll.html | File | 6.32 KB | 0644 |
|
| ToggleFormula.html | File | 6.4 KB | 0644 |
|
| ToggleRelative.html | File | 5.9 KB | 0644 |
|
| ToggleSheetGrid.html | File | 6.29 KB | 0644 |
|
| ViewHiddenColRow.html | File | 5.18 KB | 0644 |
|
| calculate.html | File | 5.73 KB | 0644 |
|
| calculation_accuracy.html | File | 7.61 KB | 0644 |
|
| cell_styles.html | File | 12.48 KB | 0644 |
|
| common_func.html | File | 5.51 KB | 0644 |
|
| common_func_workdaysintl.html | File | 9.53 KB | 0644 |
|
| data_form.html | File | 10.23 KB | 0644 |
|
| databar_more_options.html | File | 9.39 KB | 0644 |
|
| database_table_reference.html | File | 31.35 KB | 0644 |
|
| default_number_formats.html | File | 28.72 KB | 0644 |
|
| duplicate_sheet.html | File | 5.66 KB | 0644 |
|
| events_sheet.html | File | 9.13 KB | 0644 |
|
| ex_data_stat_func.html | File | 13.74 KB | 0644 |
|
| exponsmooth_embd.html | File | 22.59 KB | 0644 |
|
| formula2value.html | File | 5.49 KB | 0644 |
|
| ful_func.html | File | 10.59 KB | 0644 |
|
| func_aggregate.html | File | 26.99 KB | 0644 |
|
| func_arabic.html | File | 6.55 KB | 0644 |
|
| func_asc.html | File | 6.94 KB | 0644 |
|
| func_averageif.html | File | 25.01 KB | 0644 |
|
| func_averageifs.html | File | 22.6 KB | 0644 |
|
| func_bahttext.html | File | 6.18 KB | 0644 |
|
| func_base.html | File | 6.89 KB | 0644 |
|
| func_ceiling.html | File | 25.59 KB | 0644 |
|
| func_char.html | File | 5.9 KB | 0644 |
|
| func_clean.html | File | 5.68 KB | 0644 |
|
| func_code.html | File | 6.13 KB | 0644 |
|
| func_color.html | File | 7.68 KB | 0644 |
|
| func_concat.html | File | 7.27 KB | 0644 |
|
| func_concatenate.html | File | 5.57 KB | 0644 |
|
| func_convert.html | File | 85.18 KB | 0644 |
|
| func_countifs.html | File | 23.09 KB | 0644 |
|
| func_date.html | File | 11.69 KB | 0644 |
|
| func_datedif.html | File | 17.29 KB | 0644 |
|
| func_datevalue.html | File | 12.73 KB | 0644 |
|
| func_day.html | File | 13.09 KB | 0644 |
|
| func_days.html | File | 13.11 KB | 0644 |
|
| func_days360.html | File | 12.78 KB | 0644 |
|
| func_decimal.html | File | 6.64 KB | 0644 |
|
| func_dollar.html | File | 6.67 KB | 0644 |
|
| func_eastersunday.html | File | 11.27 KB | 0644 |
|
| func_edate.html | File | 12.72 KB | 0644 |
|
| func_eomonth.html | File | 10.99 KB | 0644 |
|
| func_error_type.html | File | 11.54 KB | 0644 |
|
| func_exact.html | File | 5.59 KB | 0644 |
|
| func_filter.html | File | 18.15 KB | 0644 |
|
| func_find.html | File | 5.89 KB | 0644 |
|
| func_findb.html | File | 7.33 KB | 0644 |
|
| func_fixed.html | File | 7.75 KB | 0644 |
|
| func_floor.html | File | 22.37 KB | 0644 |
|
| func_forecastetsadd.html | File | 21.98 KB | 0644 |
|
| func_forecastetsmult.html | File | 22.02 KB | 0644 |
|
| func_forecastetspiadd.html | File | 23.88 KB | 0644 |
|
| func_forecastetspimult.html | File | 23.92 KB | 0644 |
|
| func_forecastetsseason.html | File | 20.3 KB | 0644 |
|
| func_forecastetsstatadd.html | File | 25.96 KB | 0644 |
|
| func_forecastetsstatmult.html | File | 26.09 KB | 0644 |
|
| func_fourier.html | File | 42.78 KB | 0644 |
|
| func_hour.html | File | 10.83 KB | 0644 |
|
| func_ifs.html | File | 7.86 KB | 0644 |
|
| func_imcos.html | File | 7.96 KB | 0644 |
|
| func_imcosh.html | File | 8.38 KB | 0644 |
|
| func_imcot.html | File | 8.2 KB | 0644 |
|
| func_imcsc.html | File | 8.33 KB | 0644 |
|
| func_imcsch.html | File | 8.39 KB | 0644 |
|
| func_imsec.html | File | 8.3 KB | 0644 |
|
| func_imsech.html | File | 8.38 KB | 0644 |
|
| func_imsin.html | File | 7.93 KB | 0644 |
|
| func_imsinh.html | File | 8.36 KB | 0644 |
|
| func_imtan.html | File | 8.17 KB | 0644 |
|
| func_isoweeknum.html | File | 13.54 KB | 0644 |
|
| func_jis.html | File | 6.85 KB | 0644 |
|
| func_left.html | File | 5.64 KB | 0644 |
|
| func_leftb.html | File | 6.34 KB | 0644 |
|
| func_len.html | File | 5.54 KB | 0644 |
|
| func_lenb.html | File | 5.87 KB | 0644 |
|
| func_let.html | File | 14.03 KB | 0644 |
|
| func_lower.html | File | 5.39 KB | 0644 |
|
| func_maxifs.html | File | 22.38 KB | 0644 |
|
| func_mid.html | File | 5.04 KB | 0644 |
|
| func_midb.html | File | 8.53 KB | 0644 |
|
| func_minifs.html | File | 22.19 KB | 0644 |
|
| func_minute.html | File | 10.95 KB | 0644 |
|
| func_month.html | File | 12.79 KB | 0644 |
|
| func_networkdays.html | File | 15.42 KB | 0644 |
|
| func_networkdays.intl.html | File | 21.94 KB | 0644 |
|
| func_now.html | File | 10.49 KB | 0644 |
|
| func_numbervalue.html | File | 8.8 KB | 0644 |
|
| func_opt_barrier.html | File | 13.26 KB | 0644 |
|
| func_opt_prob_hit.html | File | 10.58 KB | 0644 |
|
| func_opt_prob_inmoney.html | File | 11.6 KB | 0644 |
|
| func_opt_touch.html | File | 13.16 KB | 0644 |
|
| func_proper.html | File | 5.48 KB | 0644 |
|
| func_randarray.html | File | 8.73 KB | 0644 |
|
| func_rawsubtract.html | File | 7.33 KB | 0644 |
|
| func_regex.html | File | 9.95 KB | 0644 |
|
| func_replace.html | File | 6.68 KB | 0644 |
|
| func_replaceb.html | File | 7.32 KB | 0644 |
|
| func_rept.html | File | 5.53 KB | 0644 |
|
| func_right.html | File | 5.63 KB | 0644 |
|
| func_rightb.html | File | 6.35 KB | 0644 |
|
| func_roman.html | File | 7.34 KB | 0644 |
|
| func_rounddown.html | File | 8.55 KB | 0644 |
|
| func_roundsig.html | File | 7.93 KB | 0644 |
|
| func_search.html | File | 8.06 KB | 0644 |
|
| func_searchb.html | File | 7.07 KB | 0644 |
|
| func_second.html | File | 10.93 KB | 0644 |
|
| func_sequence.html | File | 9.21 KB | 0644 |
|
| func_skewp.html | File | 7.48 KB | 0644 |
|
| func_sort.html | File | 16.68 KB | 0644 |
|
| func_sortby.html | File | 7.37 KB | 0644 |
|
| func_style.html | File | 9.99 KB | 0644 |
|
| func_substitute.html | File | 6.32 KB | 0644 |
|
| func_sum.html | File | 7.9 KB | 0644 |
|
| func_sumif.html | File | 20.86 KB | 0644 |
|
| func_sumifs.html | File | 22.12 KB | 0644 |
|
| func_switch.html | File | 8.34 KB | 0644 |
|
| func_t.html | File | 5.77 KB | 0644 |
|
| func_text.html | File | 6.39 KB | 0644 |
|
| func_textjoin.html | File | 8.43 KB | 0644 |
|
| func_time.html | File | 10.77 KB | 0644 |
|
| func_timevalue.html | File | 11.01 KB | 0644 |
|
| func_today.html | File | 10.43 KB | 0644 |
|
| func_trim.html | File | 5.5 KB | 0644 |
|
| func_trunc.html | File | 7.82 KB | 0644 |
|
| func_unichar.html | File | 5.53 KB | 0644 |
|
| func_unicode.html | File | 5.55 KB | 0644 |
|
| func_unique.html | File | 23.63 KB | 0644 |
|
| func_upper.html | File | 5.45 KB | 0644 |
|
| func_value.html | File | 8.58 KB | 0644 |
|
| func_webservice.html | File | 12.84 KB | 0644 |
|
| func_weekday.html | File | 18.76 KB | 0644 |
|
| func_weeknum.html | File | 19.35 KB | 0644 |
|
| func_weeknum_ooo.html | File | 14.34 KB | 0644 |
|
| func_weeknumadd.html | File | 11.01 KB | 0644 |
|
| func_workday.html | File | 14.99 KB | 0644 |
|
| func_workday.intl.html | File | 21.74 KB | 0644 |
|
| func_xlookup.html | File | 21 KB | 0644 |
|
| func_xmatch.html | File | 17.68 KB | 0644 |
|
| func_year.html | File | 11.1 KB | 0644 |
|
| func_yearfrac.html | File | 14.19 KB | 0644 |
|
| hide_sheet.html | File | 7.27 KB | 0644 |
|
| live_data_stream.html | File | 10.76 KB | 0644 |
|
| recalculate_hard.html | File | 6.4 KB | 0644 |
|
| shared_spreadsheet.html | File | 7.87 KB | 0644 |
|
| sheet_tab_color.html | File | 5.49 KB | 0644 |
|
| sidebar_alignment.html | File | 26.21 KB | 0644 |
|
| sidebar_number_format.html | File | 12.1 KB | 0644 |
|
| solver.html | File | 15.83 KB | 0644 |
|
| solver_options.html | File | 8.63 KB | 0644 |
|
| solver_options_algo.html | File | 28.26 KB | 0644 |
|
| sparklines.html | File | 12.98 KB | 0644 |
|
| stat_data.html | File | 72.41 KB | 0644 |
|
| statistics.html | File | 10.48 KB | 0644 |
|
| statistics_anova.html | File | 26.29 KB | 0644 |
|
| statistics_correlation.html | File | 21.12 KB | 0644 |
|
| statistics_covariance.html | File | 20.66 KB | 0644 |
|
| statistics_descriptive.html | File | 25.98 KB | 0644 |
|
| statistics_exposmooth.html | File | 21.47 KB | 0644 |
|
| statistics_fourier.html | File | 42.77 KB | 0644 |
|
| statistics_movingavg.html | File | 20.75 KB | 0644 |
|
| statistics_regression.html | File | 13.2 KB | 0644 |
|
| statistics_sampling.html | File | 17.34 KB | 0644 |
|
| statistics_test_chisqr.html | File | 18.29 KB | 0644 |
|
| statistics_test_f.html | File | 21.5 KB | 0644 |
|
| statistics_test_t.html | File | 22.16 KB | 0644 |
|
| statistics_test_z.html | File | 20.87 KB | 0644 |
|
| text2columns.html | File | 8.6 KB | 0644 |
|
| xml_source.html | File | 9.84 KB | 0644 |
|
| zoom.html | File | 9.62 KB | 0644 |
|