开发者

excel IF formula question

开发者 https://www.devze.com 2022-12-30 23:34 出处:网络
i am building a form开发者_开发百科ula like this: =if(a1=\"something\" or a1=\"alex\",\"returned\",\"not found\")

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")

0

精彩评论

暂无评论...
验证码 换一张
取 消