excel IF formula question
i am building a form开发者_开发百科ula like this:
=if(a1="something" or a1="alex","returned","not found")
but i guess the syntax is wrong. what is the correct way to write this?
=if(or(a1="something",a1="alex"),"returned","not found")
精彩评论