if/or statement

  • Thread starter Thread starter dchristo
  • Start date Start date
D

dchristo

ex. if d3 = cell A1 OR cell A2 OR cell B5 OR cell B6,"NOTHING FURTHER
NEEDED","CONTACT SUPERVISOR")

how do I make this work
 
Hi,

Try
=IF(OR(D3=A1,D3=A2,D3=B5,D3=B6),"NOTHING FURTHER NEEDED","CONTACT SUPERVISOR")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top