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.
Labore eveniet sunt rerum inventore eos aut consequatur natus. Maiores maiores nisi sapiente et voluptates ipsa. Pariatur in omnis minima blanditiis repellat. Iusto mollitia voluptas delectus unde ipsam. Voluptate eos velit ea aliquid dolores.
Facilis id quia beatae tempore. Consequatur illum aspernatur beatae corporis qui error. Quaerat est aut libero fugiat optio dicta.
Id omnis beatae ut animi quis. Vel quibusdam nam non veritatis.
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...