Using Ranges in OR function (EXCEL)

user_14416406 0
Viewed 41

I am learning how to use excel in school, my teacher has assigned a problem where we have to use OR to solve a problem that says:

"Show TRUE if any number is under 1500" (using OR)

These are 4 cells that are C7-F7 and the formula i used was =OR(C7:F7<1500) Teacher says its wrong, says that we have to do =OR(C7<1500,D7<1500,E7<1500,F7<1500)

Teacher says that ranges shouldn't be used with the OR function, it works for me, and i looked around on the internet anywhere where it says using ranges in OR is wrong, found nothing, so i had to ask here, thank you all.

excel-formula excel
1 Answers

Both you and your teacher are correct. Why? Because it depends on the Excel version.

In Excel 365, you can enter your formula. In previous versions of Excel, your formula will return an error, unless you know about array formulas and use Ctrl+Shift+Enter to confirm the formula.

Maybe your teacher can learn something from you today.

user_4479700
Related