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
| +98 | KISSED MY VP… HELP!!! | 16 | 14h |
| +34 | Wall Street’s premier CoC clan | 8 | 4h |
| +28 | ADHD & Living This Life | 7 | 2d |
| +26 | How expensive is SF? | 14 | 1d |
| +19 | Would you / have you payed someone for a role in IB? | 9 | 3d |
| 0 | What is a tool that you wish you had and would use every day? | 3 | 16h |
| 0 | Future of New York as number 1 financial centre | 0 | 5h |
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.
Maiores rerum odio nesciunt id et fugit. Tenetur aut necessitatibus cupiditate sunt doloremque. Officia enim recusandae ut. Ea est quasi nesciunt vel. Perferendis iusto fuga saepe ab deleniti voluptas earum.
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...