Lets say cell A1 contains 'Deloitte'. In cell A2, I want it to say 'Big 4' if cell A1 contains 'Deloitte', 'KPMG', 'Ernst & Young', or 'PWC'.
What should the formula for A2 be? I've tried
=IF(A1=OR("Deloitte","KPMG","Ernst & Young","PMC"),"Big 4","Not Big 4")
but that doesn't seem to give me the results I want
| +73 | Uchicago is paradise | 14 | 2d |
| +56 | BofA VP killed in random NYC stabbing | 36 | 17h |
| +46 | What Bank Will Make Women Instantly Fall In Love With Me? | 14 | 17h |
| +28 | How the Hell Do People Actually Get Into Private Golf Clubs? | 26 | 3d |
| +19 | Why do Asians fake their names? | 42 | 2h |
| +13 | POLL: Optimistic or Pessimistic? | 9 | 3d |
| +11 | At what salary can you start calling it “fi-NANCE” | 3 | 5h |
| +7 | Who is making these posts on WSO Linkedin ? | 5 | 2d |
| +2 | Lindsay Clansey | 1 | 3h |
| +1 | Someone just coined "the view" | 3 | 2d |
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.
OR is the logical OR, not a multiple-value returning function.
The correct version of your formula: =IF(OR(A1="Deloitte",A1="KPMG",A1="Ernst & Young",A1="PMC"),"Big 4","Not Big 4")
The OR function here evaluates each of the 4 conditions; if any are true, it returns True.
Eius velit mollitia laudantium est. Veniam magni ipsum quibusdam veritatis. In earum rerum neque ab iure voluptatem recusandae.
Quos unde rem dolorem qui qui blanditiis eum. Nihil quo a omnis accusantium.
Ut ullam enim velit inventore ad laudantium. Quo soluta doloremque repellendus. Aspernatur eius odio et veniam. Ut non aliquam accusamus facere repellendus.
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...