Cómo funciona.
SI es una función fundamental de Excel. Comprueba si se cumple una condición y devuelve un valor si es VERDADERO y otro si es FALSO. 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.
Checks whether a condition is true or false. If true, it outputs one value; if false, it outputs another.
"Think of this like a referee checking a score: IF the score is 70 or higher, they shout "Pass!"; otherwise, they shout "Fail!"."
Sintaxis.
Notación Estándar de Excel=SI(prueba_lógica; [valor_si_verdadero]; [valor_si_falso])Argumentos.
A continuación se detallan todos los parámetros aceptados por esta función.
A condition that can be evaluated to TRUE or FALSE.
Ejemplo:C2>=70The value to return if logical_test evaluates to TRUE.
Ejemplo:"Pass"The value to return if logical_test evaluates to FALSE.
Valor por defecto: "Fail"Ejemplo práctico.
Caso de Uso Paso a PasoPass/Fail Grade Check
Label student results as "Pass" if their score is 70 or above, otherwise "Fail".
| Student | Subject | Score | Status | Pass Threshold |
|---|---|---|---|---|
| Sophia | Math | 85 | — | 70 |
| Jackson | Math | 62 | — | — |
| Lucas | Math | 74 | — | — |
=IF(C2>=70, "Pass", "Fail")Evaluates IF 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()Comportamiento del resultado.
Returns "Pass" based on sample evaluation criteria and active cell references.
Buenas Prácticas
- You can nest multiple IF statements inside each other to handle more than two outcomes, although the IFS function is now preferred.
- To leave a cell blank on FALSE, use empty quotes: "" as the value_if_false.
Errores Frecuentes
- Avoid nesting more than 3-4 IF functions, as they become extremely hard to debug and maintain. Consider using IFS or VLOOKUP/XLOOKUP tables.
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écnicasHow many IF statements can be nested in modern Excel?↓
Modern Excel allows up to 64 nested IF statements, but using IFS, SWITCH, or XLOOKUP is strongly recommended for readability and performance.
How do I check multiple conditions inside an IF statement?↓
Combine IF with logical functions AND or OR, for example: =IF(AND(A2>50, B2="Approved"), "Qualify", "Disqualify").