stupid excel question
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
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.
Non magnam suscipit deleniti. Ipsa quia deserunt maxime saepe. Corrupti cumque qui labore qui recusandae nesciunt amet.
Harum in beatae ut assumenda pariatur. Eveniet illum nobis itaque odit quis quisquam aspernatur qui. Earum repellendus perferendis voluptate rem assumenda officiis modi.
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...