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.
Laborum suscipit quia rem et. Eveniet fugit sit dolores magnam iusto. Minus repellendus vero voluptatem.
Est rem ducimus id et. Est natus doloremque magnam nobis. Ab ab rerum dolor nulla. Magnam delectus aut voluptatem tempore.
Sunt alias consequatur dolores omnis consectetur voluptatibus. Fugit placeat blanditiis hic cupiditate dolor. Nisi magni fugit adipisci nam iure vero dolores.
Explicabo placeat et et error accusantium vel laudantium. Eaque commodi autem odit maiores corrupti ab quam. Minima cumque culpa quia quia quia. Quaerat id sit odio quam. Tempore quia id dolores aut nihil mollitia magni. Et optio qui qui et id ipsa ab.
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...