__ __ __ __ _____ _ _ _____ _ _ _ | \/ | \ \ / / | __ \ (_) | | / ____| | | | | | \ / |_ __\ 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>Función MIN.SI.CONJUNTO</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="minifs_function"></a>
<a id="bm_id657666576665766"></a>
<a id="bm_id658066580665806"></a> <meta itemprop="keywords" content="Función MIN.SI.CONJUNTO"> <meta itemprop="keywords" content="mínimo,satisfaciendo condiciones">
<h1 id="hd_id658866588665886" dir="auto">
<a id="minifs_head"></a>MIN.SI.CONJUNTO función</h1>
<p id="par_id659756597565975" class="paragraph" dir="auto"><span class="avis"><a id="minifs_des"></a>Devuelve el mínimo de los valores de las celdas en un intervalo que cumple varios criterios en múltiples intervalos.</span></p>
<div class="embedded">
<a id="func_head_syntax"></a>
<h3 id="hd_id126511265112651" dir="auto">Sintaxis</h3>
</div>
<p id="par_id11655988824213" class="code" dir="auto">MIN.SI.CONJUNTO(Rango_Función; Rango 1; Criterio [; Rango 2; Criterio 2][; … ; [Rango 127; Criterio 127]])</p>
<p id="par_id59901690530236" class="paragraph" dir="auto"><span class="emph">Función_Rango</span> – argumento requerido. Un rango de celdas, un nombre de un rango con nombre o una etiqueta de una columna o una fila que contiene valores para calcular el mínimo.</p>
<div class="embedded">
<a id="par00"></a>
<p id="par_id101585468691583" class="paragraph" dir="auto"><span class="emph">Intervalo 1</span>: argumento requerido. Es un intervalo de celdas, el nombre de un intervalo con nombre o la etiqueta de una columna o una fila a que se aplicará el criterio correspondiente.</p>
<a id="criterion"></a>
<p id="par_id621619279022341" class="paragraph" dir="auto"><span class="emph">Criterio</span>: Un criterio es una única celda Referencia, Número o Texto. Se utiliza en las comparaciones con el contenido de las celdas.</p>
<a id="criterion2"></a>
<p id="par_id731619279029255" class="paragraph" dir="auto">Una referencia a una celda vacía se interpreta como el valor numérico 0.</p>
<p id="par_id31619279035359" class="paragraph" dir="auto">Una expresión coincidente puede ser:</p>
<ul itemprop="Unordered" itemscope="true" itemtype="http://schema.org/ItemList" dir="auto">
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id171619279059462" class="listitem" dir="auto">A number or logical value. A matching cell content equals the number or logical value.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id511619279076504" class="listitem" dir="auto">A value beginning with a comparator (<span class="emph"><</span>, <span class="emph"><=</span>, <span class="emph">=</span>, <span class="emph">></span>, <span class="emph">>=</span>, <span class="emph"><></span>).</p>
<p id="par_id11619279168512" class="paragraph" dir="auto">En el caso de <span class="emph">=</span>, si el valor está vacío, coincide con las celdas vacías.</p>
<p id="par_id161619279207350" class="paragraph" dir="auto">En el caso de <span class="emph"><></span>, si el valor está vacío, coincide con las celdas no vacías.</p>
<p id="par_id271619279215695" class="paragraph" dir="auto">For <span class="emph"><></span>, if the value is not empty it matches any cell content except the value, including empty cells.</p>
<p id="par_id861619279223855" class="paragraph" dir="auto"><span class="emph">Nota</span>"=0" no coincide con las celdas vacías.</p>
<p id="par_id51619279363954" class="paragraph" dir="auto">For <span class="emph">=</span> and <span class="emph"><></span>, if the value is not empty and can not be interpreted as a number type or one of its subtypes and the property <a target="_top" href="es/text/shared/optionen/01060500.html">Search criteria <span class="emph">=</span> and <span class="emph"><></span> must apply to whole cells</a> is checked, comparison is against the entire cell contents, if unchecked, comparison is against any subpart of the field that matches the criteria. For <span class="emph">=</span> and <span class="emph"><></span>, if the value is not empty and can not be interpreted as a Number type or one of its subtypes applies.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id801619279323556" class="listitem" dir="auto">Other Text value. If the property <a target="_top" href="es/text/shared/optionen/01060500.html">Search criteria <span class="emph">=</span> and <span class="emph"><></span> must apply to whole cells</a> is true, the comparison is against the entire cell contents, if false, comparison is against any subpart of the field that matches the criteria. The expression can contain text, numbers, regular expressions or wildcards (<a target="_top" href="es/text/shared/optionen/01060500.html#wildcards">if enabled in calculation options</a>).</p>
</li>
</ul>
<p id="par_id190621657742" class="paragraph" dir="auto"><span class="emph">Intervalo2</span>: opcional. Intervalo2 y todos los argumentos siguientes tienen el mismo significado que Intervalo1.</p>
<p id="par_id317001803813193" class="paragraph" dir="auto"><span class="emph">Criterio 2 </span>– Opcional. Criterio2 y todos los promedios significan lo mismo que Criterio.</p>
</div>
<div class="embedded">
<a id="regex"></a>
<p id="par_id3147418" class="paragraph" dir="auto">La búsqueda admite tanto comodines como <a target="_top" href="es/text/shared/01/02100001.html">expresiones regulares</a>. Si activa las expresiones regulares, puede introducir «tod.*», por ejemplo, para encontrar la primera localización de «tod» seguido de cualesquier caracteres. Si desea localizar un texto que es también una expresión regular, debe anteponer a cada uno de los metacaracteres u operadores de la expresión una contrabarra «\», o circundarlo con \Q...\E. Puede activar o desactivar la valoración automática de los comodines o las expresiones regulares en <a target="_top" href="es/text/shared/optionen/01060500.html"><span id="swlnsystextshared0000000001xml_3" class="switchinline"><span hidden="true" id="MACtextshared0000000001xml_3" class="MAC"><span class="menuitem">LibreOffice ▸ Preferencias</span></span><span hidden="true" id="defaulttextshared0000000001xml_3"><span class="menuitem">Herramientas ▸ Opciones</span></span></span><span class="menuitem"> ▸ LibreOffice Calc ▸ Calcular</span></a>.</p>
<a id="regexnumex"></a>
<div class="warning">
<div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/warning.svg" alt="warning" style="width:40px;height:40px;"></div>
<div class="notetext"><p id="par_id651572973288601" dir="auto">Al utilizar funciones en las que uno o más argumentos son cadenas de criterios de búsqueda que representan una expresión regular, en primer lugar se intentará convertir los criterios de la cadena en números. Por ejemplo, «.0» se convertirá en 0.0 y así sucesivamente. Si el intento es fructuoso, la correspondencia no será por expresión regular, sino numérica. No obstante, si se cambia a una configuración regional en la cual el separador decimal no es el punto, pasará a valer la expresión regular. Para forzar la evaluación de la expresión regular en lugar de una expresión numérica, utilice una expresión que no pueda confundirse con un número, como por ejemplo «.\0» o «(?i).0».</p></div>
</div>
<br>
</div>
<div class="embedded">
<a id="warning01"></a>
<p id="par_id14734320631377" class="paragraph" dir="auto"><span class="emph">Funcion_Rango</span> y <span class="emph">Rango 1, Rango 2...</span>debe tener el mismo tamaño, de lo contrario, la función devuelve error: 502 - Argumento no válido.</p>
</div>
<div class="embedded">
<a id="note01"></a>
<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_id94162948227556" dir="auto">La relación lógica entre los criterios puede definirse como Y lógico (conjunción). En otras palabras, si y sólo si se cumplen todos los criterios dados, un valor de la celda correspondiente del<span class="emph">Función_Rango</span>se tiene en cuenta en el cálculo.</p></div>
</div>
<br>
</div>
<div class="embedded">
<a id="par01"></a>
<p id="par_id191527781733238" class="paragraph" dir="auto">La función puede tener hasta 255 argumentos, lo que significa que es posible especificar hasta 127 intervalos de criterios y sus criterios correspondientes.</p>
<p id="par_id175721789527973" class="paragraph" dir="auto">Si una celda contiene VERDADERO se tratará como 1; si contiene FALSO, como 0 (cero).</p>
</div>
<div class="embedded">
<a id="func_head_example"></a>
<h3 id="hd_id980889808898088" dir="auto">Ejemplos</h3>
</div>
<div class="embedded">
<a id="ex_func_average"></a>
<a id="ex_func_average_table"></a>
<p id="hd_id2609201512474295" class="paragraph" dir="auto">Tenga en cuenta la tabla siguiente</p>
<table border="1" class="" cellpadding="0" cellspacing="0">
<tr>
<td rowspan="" colspan="" dir="auto">
</td>
<th rowspan="" colspan="" class="tableheadcell" dir="auto">
<p id="par_id2509201517430799" class="tableheadintable" dir="auto">A</p>
</th>
<th rowspan="" colspan="" class="tableheadcell" dir="auto">
<p id="par_id250920151743116" class="tableheadintable" dir="auto">B</p>
</th>
<th rowspan="" colspan="" class="tableheadcell" dir="auto">
<p id="par_id2509201517431582" class="tableheadintable" dir="auto">C</p>
</th>
</tr>
<tr>
<th rowspan="" colspan="" class="tableheadcell" dir="auto">
<p id="par_id2509201517431967" class="tableheadintable" dir="auto">1</p>
</th>
<td rowspan="" colspan="" dir="auto">
<p id="par_id18260631312423" class="tablecontentintable" dir="auto">Nombre de producto</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_id2509201517433075" class="tablecontentintable" dir="auto">Sales</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_id2509201519383294" class="tablecontentintable" dir="auto">Revenue</p>
</td>
</tr>
<tr>
<th rowspan="" colspan="" class="tableheadcell" dir="auto">
<p id="par_id959660094035" class="tableheadintable" dir="auto">2</p>
</th>
<td rowspan="" colspan="" dir="auto">
<p id="par_id2855779586764" class="tablecontentintable" dir="auto">lápiz</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_id110202156219769" class="tablecontentintable" dir="auto">20</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_id23281929326512" class="tablecontentintable" dir="auto">65</p>
</td>
</tr>
<tr>
<th rowspan="" colspan="" class="tableheadcell" dir="auto">
<p id="par_id2509201517432278" class="tableheadintable" dir="auto">3</p>
</th>
<td rowspan="" colspan="" dir="auto">
<p id="par_id24967262611733" class="tablecontentintable" dir="auto">bolígrafo</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_id2509201517433391" class="tablecontentintable" dir="auto">35</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_id250920151938352" class="tablecontentintable" dir="auto">85</p>
</td>
</tr>
<tr>
<th rowspan="" colspan="" class="tableheadcell" dir="auto">
<p id="par_id250920151743267" class="tableheadintable" dir="auto">4</p>
</th>
<td rowspan="" colspan="" dir="auto">
<p id="par_id252542413030532" class="tablecontentintable" dir="auto">cuaderno</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_id2509201517433781" class="tablecontentintable" dir="auto">20</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_id2509201519383822" class="tablecontentintable" dir="auto">190</p>
</td>
</tr>
<tr>
<th rowspan="" colspan="" class="tableheadcell" dir="auto">
<p id="par_id2509201519371339" class="tableheadintable" dir="auto">5</p>
</th>
<td rowspan="" colspan="" dir="auto">
<p id="par_id2509201519374677" class="tablecontentintable" dir="auto">libro</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_id2509201519373350" class="tablecontentintable" dir="auto">17</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_id2509201519384171" class="tablecontentintable" dir="auto">180</p>
</td>
</tr>
<tr>
<th rowspan="" colspan="" class="tableheadcell" dir="auto">
<p id="par_id591711556978009" class="tableheadintable" dir="auto">6</p>
</th>
<td rowspan="" colspan="" dir="auto">
<p id="par_id491711556981497" class="tablecontentintable" dir="auto">estuche</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_id981711556984697" class="tablecontentintable" dir="auto">not</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_id581711556987385" class="tablecontentintable" dir="auto">not</p>
</td>
</tr>
</table>
<br>
<div class="warning">
<div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/warning.svg" alt="warning" style="width:40px;height:40px;"></div>
<div class="notetext"><p id="par_id1191767622119" dir="auto">En todos los ejemplos siguientes, los intervalos utilizados para el cálculo incluyen la fila n.º 6, pero se ignorará debido a que contiene texto.</p></div>
</div>
<br>
</div>
<h4 id="hd_id193452436229521" dir="auto">Uso simple</h4>
<p id="par_id94321051525036" class="paragraph" dir="auto"><span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=MIN.SI.CONJUNTO(B2:B6;B2:B6;"<35")</span></p>
<p id="par_id28647227259438" class="paragraph" dir="auto">Calcula el mínimo de valores del rango B2:B6 que son menores o iguales a 20. Devuelve 17.</p>
<p id="par_id36952767622741" class="paragraph" dir="auto"><span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=MIN.SI.CONJUNTO(C2:C6;B2:B6;">=20";C2:C6;">90")</span></p>
<p id="par_id189772445525114" class="paragraph" dir="auto">Calcula el mínimo de valores del rango C2:C6 que son menores a 90 y corresponden a celdas del rango B2:B6 con valores mayores o iguales a 20. Devuelve 190.</p>
<h4 id="hd_id30455222431067" dir="auto">Uso de expresiones regulares y funciones anidadas</h4>
<p id="par_id307691022525348" class="paragraph" dir="auto"><span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=MIN.SI.CONJUNTO(C2:C6;B2:B6;">"&MÍNIMO(B2:B6);B2:B6;"<"&MÁXIMO(B2:B6))</span></p>
<p id="par_id27619246864839" class="paragraph" dir="auto">Calcula el mínimo de valores del rango C2:C6 que corresponden a todos los valores del rango B2:B6 excepto su mínimo y máximo. Devuelve 65.</p>
<p id="par_id220502883332563" class="paragraph" dir="auto"><span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=MIN.SI.CONJUNTO(C2:C6;A2:A6;".*libro";B2:B6;">"&MÍNIMO(B2:B6))</span></p>
<p id="par_id15342189586295" class="paragraph" dir="auto">Calcula el mínimo de valores del intervalo C2:C6 que corresponden a todas las celdas del intervalo A2:A6 que terminan en «libro» y a todas las celdas del intervalo B2:B6 salvo su mínimo. Devuelve 190.</p>
<h4 id="hd_id8168283329426" dir="auto">Referencia a una celda como criterio</h4>
<p id="par_id50762995519951" class="paragraph" dir="auto">Si necesita cambiar un criterio fácilmente, puede especificarlo en una celda separada y usar una referencia a esta celda en la condición de la función MIN.SI.CONJUNTO. Por ejemplo, la función anterior se puede reescribir de la siguiente manera:</p>
<p id="par_id135761606425300" class="paragraph" dir="auto"><span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">=MIN.SI.CONJUNTO(C2:C6;A2:A6;".*"&E2;B2:B6;"<"&MÁXIMO(B2:B6))</span></p>
<p id="par_id30574750215839" class="paragraph" dir="auto">Si E2 = «libro», la función devuelve 180, porque la referencia a la celda se sustituye por su contenido.</p>
<div class="embedded">
<a id="func_ifs"></a>
<p id="par_id721528312694192" class="paragraph" dir="auto"></p>
</div>
<div class="embedded">
<a id="sectiontechinfo"></a>
<h4 id="hd_id301640873452726" dir="auto">Información técnica</h4>
</div>
<div class="embedded">
<a id="5.2"></a>
<div class="tip">
<div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/tip.svg" alt="tip" style="width:40px;height:40px;"></div>
<div class="notetext"><p id="par_id651551401041652" dir="auto">Esta función está disponible desde la versión 5.2 de LibreOffice.</p></div>
</div>
<br>
</div>
<div class="embedded">
<a id="notODFF"></a>
<p id="par_id251640873774457" class="paragraph" dir="auto">Esta función no forma parte de la norma <span class="emph">Formato de Documentos Abierto para Aplicaciones de Oficina (OpenDocument), versión 1.3. Parte 4: formato de fórmulas recalculadas (OpenFormula)</span>. El espacio de nombres es</p>
</div>
<p id="par_id341640873986703" class="paragraph" dir="auto"><span class="literal">COM.MICROSOFT.MINIFS</span></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">
<div class="tip">
<div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/tip.svg" alt="tip" style="width:40px;height:40px;"></div>
<div class="notetext"><p id="par_id941677015454359" dir="auto"><a target="_blank" href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/MINIFS">MINIFS wiki page</a>.</p></div>
</div>
<br>
<p id="par_id11921178730928" class="paragraph" dir="auto">
<a target="_top" href="es/text/scalc/01/04060184.html#max">MAX</a>,
<a target="_top" href="es/text/scalc/01/04060184.html#maxa">MAXA</a>,
<a target="_top" href="es/text/scalc/01/04060184.html#min">MIN</a>,
<a target="_top" href="es/text/scalc/01/04060184.html#mina">MINA</a>,
</p>
<p id="par_id11931178730928" class="paragraph" dir="auto">
<a target="_top" href="es/text/scalc/01/func_countifs.html">CONTAR.SI.CONJUNTO</a>,
<a target="_top" href="es/text/scalc/01/func_minifs.html">MIN.SI.CONJUNTO</a>,
Función <a target="_top" href="es/text/scalc/01/func_maxifs.html">MAX.SI.CONJUNTO</a>,
<a target="_top" href="es/text/scalc/01/func_averageifs.html">PROMEDIO.SI.CONJUNTO</a>,
<a target="_top" href="es/text/scalc/01/func_sumifs.html">SUMAR.SI.CONJUNTO</a>
</p>
<p id="par_id15970172625152" class="paragraph" dir="auto"><a target="_top" href="es/text/shared/01/02100001.html">Lista de expresiones regulares</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/func_minifs.xhp" target="_blank">/text/scalc/01/func_minifs.xhp</a></p>
<p dir="auto">Title is: Función MIN.SI.CONJUNTO</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 |
|