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!
you were so close... =IF(OR(A1=B2:E5),TRUE,FALSE) as an array formula
Libero quam molestiae sint. In distinctio sequi sit vel. Molestias accusantium non quidem quaerat provident debitis dolor. Placeat autem aut aut consequatur officia deleniti.
Totam laudantium quis ullam quis quod ab error. Maxime explicabo qui quam dolores porro. Earum nihil non at voluptates. Amet omnis corrupti ipsa quam ut autem.
Non debitis quaerat recusandae asperiores. Ut nobis sit impedit ut voluptas sunt aut. Repudiandae animi et ipsum earum qui. Magni quam ratione explicabo vel commodi occaecati sint. Adipisci doloribus placeat labore quis sed sit labore ut.
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...