Cómo funciona.
O es una función fundamental de Excel. Devuelve VERDADERO si al menos un argumento es verdadero; devuelve FALSO si todos son falsos. 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 multiple rules. It outputs TRUE if at least one rule is met; it only outputs FALSE if all rules fail.
"Think of this like qualifying for a free drink. You qualify IF you have a coupon OR it is your birthday. You only need one of them to be true!"
Sintaxis.
Notación Estándar de Excel=O(valor_lógico1; [valor_lógico2]; ...)Argumentos.
A continuación se detallan todos los parámetros aceptados por esta función.
The first condition to test.
Ejemplo:B2<=18Additional conditions to test.
Ejemplo:C2="Yes"Ejemplo práctico.
Caso de Uso Paso a PasoDiscount Qualifier
Verify if student age is 18 or under OR student ID status in column C is "Yes".
| Age | Student ID | Status | Qualifies | |
|---|---|---|---|---|
| 21 | Yes | Active | — | — |
| 17 | No | Active | — | — |
| 25 | No | Active | — | — |
=OR(B2<=18, C2="Yes")Evaluates OR 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.
=O()Comportamiento del resultado.
Returns "Calculated output" based on sample evaluation criteria and active cell references.
Buenas Prácticas
- Use OR to check if a cell contains one of several options: e.g. `=OR(A2="Red", A2="Green", A2="Blue")`.
Errores Frecuentes
- If you supply array ranges to OR, they must be formatted correctly, otherwise it can return #VALUE! or slow down calculation.
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 OR 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: =OR(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 OR?↓
If you supply array ranges to OR, they must be formatted correctly, otherwise it can return #VALUE! or slow down calculation.
Does OR work identically in Google Sheets?↓
Yes, OR is supported in both Microsoft Excel and Google Sheets with standard evaluation behavior.