Pretty simple one here. I am doing an IF function, and the condition I am testing is whether one cell (let's call it A1) equals a number of cells - let's call those cells B2, C3, D4, and E5. If A1 equals at least one of those four cells, the condition is true. Is there a simpler way to write this than:
=IF(OR(A1=B2,A1=C3,A1=D4,A1=E5),TRUE,FALSE)
I'm looking for something like:
=IF(A1=OR(B2:E5),TRUE,FALSE)
That doesn't work.
Thanks!
| +158 | UBS Tech layoff | 52 | 22h |
| +147 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 23 | 2h |
| +145 | UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT | 31 | 1h |
| +60 | Are target prospects getting dumber? | 27 | 13m |
| +58 | How do YOU manage networking requests? | 17 | 7h |
| +48 | Leaked Interview Questions to Recruiting Services | 31 | 13m |
| +36 | Quitting After First 4 months | 12 | 1d |
| +34 | MBB Pay Raises | 26 | 1d |
| +33 | Cornell Club T10 Rankings (UPDATED 10/2026) | 19 | 1d |
| +19 | Career Crossroads | 2 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
you were so close... =IF(OR(A1=B2:E5),TRUE,FALSE) as an array formula
Accusantium sint excepturi ut consectetur reiciendis. Ipsa aut voluptate natus quo praesentium.
Aut accusamus et qui perferendis. Qui qui porro quia.
Dolores consectetur adipisci beatae odio dolor dolorum temporibus. Sint quod id harum autem perspiciatis veniam. Cumque nesciunt maiores earum in in omnis. Cumque eveniet odio quis dolore est ad. Nobis dolor quas accusantium quae nobis voluptatem.
Earum non enim alias. Suscipit et esse earum explicabo consequatur rerum ipsa. Iusto sit distinctio natus ex voluptatibus aperiam ab. Necessitatibus nobis accusamus omnis sed odit. Quos consequatur qui quas repudiandae quam.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...