Cómo funciona.
SI.ERROR es una función fundamental de Excel. Devuelve un valor especificado si una fórmula genera un error; de lo contrario, devuelve el resultado de la fórmula. Permite automatizar hojas de cálculo, simplificar fórmulas complejas y analizar datos con total precisión en Microsoft Excel y Google Sheets.
💡 En palabras sencillas.
Runs a formula, but if the formula fails (like a division by zero error), it gives a clean default value instead of Excel's ugly errors.
"Think of this like a protective shield. If your math equation tries to divide by zero and would explode with a weird error, the shield turns it into a friendly 0."
Sintaxis.
Notación Estándar de Excel=SI.ERROR(valor; valor_si_error)Argumentos.
A continuación se detallan todos los parámetros aceptados por esta función.
The formula, expression, or cell reference to check for an error.
Ejemplo:B2/C2The value to return if the formula evaluates to an error.
Ejemplo:0Ejemplo práctico.
Caso de Uso Paso a PasoCalculate Division Average
Calculate average sale value (Sales / Orders). Handle cases where orders are 0 to prevent #DIV/0! errors.
| Category | Total Revenue | Total Orders | Average Order Value | Error Shield |
|---|---|---|---|---|
| Electronics | 45000 | 150 | — | On |
| Apparel | 12000 | 40 | — | — |
| Home Decor | 0 | 0 | — | — |
=IFERROR(B2/C2, 0)Evaluates IFERROR over the sample table cells, placing the verified output in cell D2:D6.
Generador de fórmula.
Abrir Asistente CompletoPersonaliza los campos de argumento a continuación para generar una fórmula lista para copiar y pegar en tu hoja de cálculo.
=SI.ERROR()Comportamiento del resultado.
Returns "Calculated output" based on sample evaluation criteria and active cell references.
Buenas Prácticas
- Use an empty string "" as the value_if_error to make error rows look completely clean and blank.
- Wrap lookups (like VLOOKUP) in IFERROR to handle items that are not in your reference tables.
Errores Frecuentes
- IFERROR catches *all* errors, including spelling mistakes in your formula names. Be careful as it can hide bugs you actually want to fix.
Compatibilidad de plataforma y versiones.
Matriz verificada con base en los motores de cálculo oficiales de Microsoft Excel y Google Sheets.
Core standard function supported across all modern and legacy Microsoft Excel versions (365, 2021, 2019, 2016, 2013, 2010), as well as Excel for the Web and Mac.
100% compatible with Google Sheets. Uses identical argument order, data types, and standard calculation logic.
Preguntas frecuentes.
Dudas TécnicasCan I use IFERROR across different worksheets in Excel?↓
Yes. You can reference cells located on other sheets by including the sheet name followed by an exclamation mark, for example: =IFERROR(Sheet2!A2:A10). If the sheet name contains spaces, enclose it in single quotes: ='Q1 Report'!A2:A10.
What is the most common reason for errors in IFERROR?↓
IFERROR catches *all* errors, including spelling mistakes in your formula names. Be careful as it can hide bugs you actually want to fix.
Does IFERROR work identically in Google Sheets?↓
Yes, IFERROR is supported in both Microsoft Excel and Google Sheets with standard evaluation behavior.