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
| +95 | Are you “less ambitious” for having long term goals outside of NYC | 24 | 18h | |
| +43 | Interviews Are So Fake | 27 | 56m | |
| +33 | 2024 UK Election - Tories finished? | 20 | 1d | |
| +29 | Being Christian in investment banking | 14 | 23h | |
| +26 | Is my boss gaslighting me? | 3 | 6d | |
| +23 | Non-Competes Banned | 21 | 1m | |
| +21 | Sabotaging Peers to Get Ahead? | 34 | 4d | |
| How do I become Sigma | 13 | 3h | ||
| +18 | Moelis has the cutest Analysts? | 4 | 20h | |
| +18 | Best NYC neighborhood for single 30M | 12 | 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.
At et magnam qui non. Praesentium sit aliquam qui nulla iusto. Sed ea consequatur necessitatibus consequatur enim cupiditate.
Facilis dolorem aut non qui porro sapiente. Voluptas sit et perferendis commodi. Qui doloribus et culpa non aut qui sed voluptatem. Illum veniam molestiae similique sit.
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...