__ __ __ __ _____ _ _ _____ _ _ _ | \/ | \ \ / / | __ \ (_) | | / ____| | | | | | \ / |_ __\ 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>Calcular con fórmulas</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_id3155411"></a><meta itemprop="keywords" content="fórmulas,calcular con"> <meta itemprop="keywords" content="calcular, con fórmulas"> <meta itemprop="keywords" content="ejemplos,cálculo con fórmula"> <h1 id="hd_id3155411" dir="auto"> <a id="formulas"></a> Calcular con fórmulas </h1> <p id="par_id3156281" class="paragraph" dir="auto">Todas las fórmulas empiezan por un signo de igualdad. Las fórmulas pueden contener números, texto, operadores aritméticos y lógicos o funciones.</p> <div class="tip"> <div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/tip.svg" alt="Icono de consejo" style="width:40px;height:40px;"></div> <div class="notetext"><p dir="auto">Recuerde que se pueden emplear los operadores aritméticos básicos (+, -, *, /) en las fórmulas según la norma «las multiplicaciones y las divisiones tienen prioridad sobre las sumas y las restas». Es más simple utilizar =A1+B1 que =SUMA(A1:B1).</p></div> </div> <br> <div class="tip"> <div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/tip.svg" alt="Icono de consejo" style="width:40px;height:40px;"></div> <div class="notetext"><p dir="auto">Se pueden utilizar paréntesis. El resultado de la fórmula =(1+2)*3 es distinto del resultado de =1+2*3.</p></div> </div> <br> <p id="par_id3156285" class="paragraph" dir="auto">Aquí dispone de algunos ejemplos de fórmulas de LibreOffice Calc:</p> <table border="1" class="" cellpadding="0" cellspacing="0"> <tr> <td rowspan="" colspan="" dir="auto"> <p id="par_id3154015" class="paragraphintable" dir="auto">=A1+10</p> </td> <td rowspan="" colspan="" dir="auto"> <p id="par_id3146972" class="paragraphintable" dir="auto">Muestra el contenido de A1 elevado a 10.</p> </td> </tr> <tr> <td rowspan="" colspan="" dir="auto"> <p id="par_id3145643" class="paragraphintable" dir="auto">=A1*16%</p> </td> <td rowspan="" colspan="" dir="auto"> <p id="par_id3154255" class="paragraphintable" dir="auto">Muestra un 16 % del contenido de A1.</p> </td> </tr> <tr> <td rowspan="" colspan="" dir="auto"> <p id="par_id3146917" class="paragraphintable" dir="auto">=A1 * A2</p> </td> <td rowspan="" colspan="" dir="auto"> <p id="par_id3146315" class="paragraphintable" dir="auto">Muestra el resultado de la multiplicación de A1 y A2.</p> </td> </tr> <tr> <td rowspan="" colspan="" dir="auto"> <p id="par_id3154022" class="paragraphintable" dir="auto">=REDONDEAR(A1;1)</p> </td> <td rowspan="" colspan="" dir="auto"> <p id="par_id3150363" class="paragraphintable" dir="auto">Muestra el contenido de la celda A1 redondeado un decimal.</p> </td> </tr> <tr> <td rowspan="" colspan="" dir="auto"> <p id="par_id3150209" class="paragraphintable" dir="auto">=INT.EFECTIVO(5%;12)</p> </td> <td rowspan="" colspan="" dir="auto"> <p id="par_id3150883" class="paragraphintable" dir="auto">Calcula el interés efectivo para un interés nominal del 5 % con 12 pagos anuales.</p> </td> </tr> <tr> <td rowspan="" colspan="" dir="auto"> <p id="par_id3146114" class="paragraphintable" dir="auto">=B8-SUMA(B10:B14)</p> </td> <td rowspan="" colspan="" dir="auto"> <p id="par_id3154486" class="paragraphintable" dir="auto">Calcula B8 menos la suma de las celdas B10 a B14.</p> </td> </tr> <tr> <td rowspan="" colspan="" dir="auto"> <p id="par_id3152890" class="paragraphintable" dir="auto">=SUMA(B8;SUMA(B10:B14))</p> </td> <td rowspan="" colspan="" dir="auto"> <p id="par_id3159171" class="paragraphintable" dir="auto">Calcula la suma de las celdas B10 hasta la B14 y suma el valor en B8.</p> </td> </tr> </table> <br> <p id="par_id3150109" class="paragraph" dir="auto">Como se muestra en el ejemplo, es posible anidar funciones dentro de fórmulas. También se pueden anidar funciones dentro de funciones. El Asistente para funciones sirve de ayuda para anidar funciones.</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="embedded"><p class="embedded" dir="auto"><a target="_top" href="es/text/scalc/guide/formula_enter.html">Introducir fórmulas</a></p></div> <p id="par_id3150213" class="paragraph" dir="auto"><a target="_top" href="es/text/scalc/01/04060100.html">Lista de las funciones</a></p> <p id="par_id3152869" class="paragraph" dir="auto"><a target="_top" href="es/text/scalc/01/04060000.html">Asistente para funciones</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/guide/formulas.xhp" target="_blank">/text/scalc/guide/formulas.xhp</a></p> <p dir="auto">Title is: Calcular con fórmulas</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 |
|---|---|---|---|---|
| address_auto.html | File | 8.38 KB | 0644 |
|
| auto_off.html | File | 8.69 KB | 0644 |
|
| autofilter.html | File | 9.01 KB | 0644 |
|
| autoformat.html | File | 8.89 KB | 0644 |
|
| background.html | File | 7.14 KB | 0644 |
|
| borders.html | File | 19.28 KB | 0644 |
|
| calc_date.html | File | 7.81 KB | 0644 |
|
| calc_series.html | File | 10.44 KB | 0644 |
|
| calc_timevalues.html | File | 5.14 KB | 0644 |
|
| calculate.html | File | 6.74 KB | 0644 |
|
| cell_enter.html | File | 7.3 KB | 0644 |
|
| cell_protect.html | File | 10.78 KB | 0644 |
|
| cell_unprotect.html | File | 5.62 KB | 0644 |
|
| cellcopy.html | File | 7.74 KB | 0644 |
|
| cellreference_dragdrop.html | File | 7.72 KB | 0644 |
|
| cellreferences.html | File | 11.9 KB | 0644 |
|
| cellreferences_url.html | File | 7.96 KB | 0644 |
|
| cellstyle_by_formula.html | File | 7.65 KB | 0644 |
|
| cellstyle_conditional.html | File | 15.61 KB | 0644 |
|
| cellstyle_minusvalue.html | File | 6.35 KB | 0644 |
|
| change_image_anchor.html | File | 6.32 KB | 0644 |
|
| consolidate.html | File | 10.92 KB | 0644 |
|
| csv_files.html | File | 11.55 KB | 0644 |
|
| csv_formula.html | File | 10.76 KB | 0644 |
|
| currency_format.html | File | 8.22 KB | 0644 |
|
| database_define.html | File | 7.69 KB | 0644 |
|
| database_filter.html | File | 9.68 KB | 0644 |
|
| database_sort.html | File | 6.41 KB | 0644 |
|
| datapilot.html | File | 6.16 KB | 0644 |
|
| datapilot_createtable.html | File | 10.48 KB | 0644 |
|
| datapilot_deletetable.html | File | 6.3 KB | 0644 |
|
| datapilot_edittable.html | File | 7.81 KB | 0644 |
|
| datapilot_filtertable.html | File | 10.38 KB | 0644 |
|
| datapilot_formatting.html | File | 8.92 KB | 0644 |
|
| datapilot_grouping.html | File | 7.26 KB | 0644 |
|
| datapilot_tipps.html | File | 6.88 KB | 0644 |
|
| datapilot_updatetable.html | File | 6.19 KB | 0644 |
|
| dbase_files.html | File | 11.02 KB | 0644 |
|
| design.html | File | 7.99 KB | 0644 |
|
| edit_multitables.html | File | 6.62 KB | 0644 |
|
| filters.html | File | 7.62 KB | 0644 |
|
| finding.html | File | 10.58 KB | 0644 |
|
| format_table.html | File | 8.82 KB | 0644 |
|
| format_value.html | File | 7.63 KB | 0644 |
|
| format_value_userdef.html | File | 9.76 KB | 0644 |
|
| formula_copy.html | File | 7.72 KB | 0644 |
|
| formula_enter.html | File | 8.59 KB | 0644 |
|
| formula_value.html | File | 6.03 KB | 0644 |
|
| formulas.html | File | 8.04 KB | 0644 |
|
| fraction_enter.html | File | 5.9 KB | 0644 |
|
| goalseek.html | File | 8.18 KB | 0644 |
|
| html_doc.html | File | 7.58 KB | 0644 |
|
| integer_leading_zero.html | File | 8.69 KB | 0644 |
|
| keyboard.html | File | 11.18 KB | 0644 |
|
| line_fix.html | File | 7.31 KB | 0644 |
|
| main.html | File | 22.03 KB | 0644 |
|
| mark_cells.html | File | 9.18 KB | 0644 |
|
| matrixformula.html | File | 6.91 KB | 0644 |
|
| move_dragdrop.html | File | 12.43 KB | 0644 |
|
| multi_tables.html | File | 7.63 KB | 0644 |
|
| multioperation.html | File | 13.52 KB | 0644 |
|
| multitables.html | File | 6.77 KB | 0644 |
|
| note_insert.html | File | 7.54 KB | 0644 |
|
| numbers_text.html | File | 12.24 KB | 0644 |
|
| pivotchart.html | File | 6.17 KB | 0644 |
|
| pivotchart_create.html | File | 7.84 KB | 0644 |
|
| pivotchart_delete.html | File | 5.96 KB | 0644 |
|
| pivotchart_edit.html | File | 9.88 KB | 0644 |
|
| pivotchart_filter.html | File | 6.71 KB | 0644 |
|
| pivotchart_update.html | File | 6.06 KB | 0644 |
|
| print_details.html | File | 7.93 KB | 0644 |
|
| print_exact.html | File | 6.63 KB | 0644 |
|
| print_landscape.html | File | 9.3 KB | 0644 |
|
| print_title_row.html | File | 8.69 KB | 0644 |
|
| printranges.html | File | 10.55 KB | 0644 |
|
| relativ_absolut_ref.html | File | 15.06 KB | 0644 |
|
| remove_duplicates.html | File | 7.93 KB | 0644 |
|
| rename_table.html | File | 11.37 KB | 0644 |
|
| rounding_numbers.html | File | 8.35 KB | 0644 |
|
| row_height.html | File | 7.27 KB | 0644 |
|
| scenario.html | File | 9.74 KB | 0644 |
|
| sorted_list.html | File | 6.63 KB | 0644 |
|
| specialfilter.html | File | 14.18 KB | 0644 |
|
| subtotaltool.html | File | 9.5 KB | 0644 |
|
| super_subscript.html | File | 5.9 KB | 0644 |
|
| table_cellmerge.html | File | 13.29 KB | 0644 |
|
| table_rotate.html | File | 6.15 KB | 0644 |
|
| table_view.html | File | 6.5 KB | 0644 |
|
| text_numbers.html | File | 6.6 KB | 0644 |
|
| text_rotate.html | File | 5.76 KB | 0644 |
|
| text_wrap.html | File | 6.23 KB | 0644 |
|
| userdefined_function.html | File | 11.89 KB | 0644 |
|
| validity.html | File | 10.36 KB | 0644 |
|
| value_with_name.html | File | 10.87 KB | 0644 |
|
| webquery.html | File | 10.32 KB | 0644 |
|
| wildcards.html | File | 12.76 KB | 0644 |
|
| year2000.html | File | 5.59 KB | 0644 |
|