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
| +75 | Ukraine, geopolitics, midterms | 29 | 1d |
| +52 | Press Secretary had shortest stint EVER | 25 | 9h |
| +17 | Bankers with reptiles | 8 | 2d |
| +7 | Being able to DnD is God Mode | 7 | 20h |
| +4 | Going to work with Helicopter | 3 | 12h |
| +3 | Coworkers who try to change management, fail, but are ultimately correct? | 4 | 47m |
| 0 | Which IB Target School Has the Hottest Girls? | 3 | 5d |
| 0 | What can be automated using AI? | 3 | 9h |
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.
Excepturi nemo harum voluptatem. Perspiciatis ea qui voluptas.
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...