Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

CONDITION IS salclass='1009' or salclass='1010' then output is steel or salclass='1002' or salclass='1003' then output is color otherwise other?

PLs tell me for above scenario to  write  expression

4 Replies
Not applicable
Author


if(salclass='1009' or salclass='1010','steel',if(salclass='1002' or salclass-'1003',color','other')))

Not applicable
Author

You can also use match

Not applicable
Author

=if(match(salclass,1009,1010),'steel',if(match(salclass,1002,1003),'color','other'))

I think the 'match' function is a best practice.

Not applicable
Author

tell me   using  match  function  pls