Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
PLs tell me for above scenario to write expression
if(salclass='1009' or salclass='1010','steel',if(salclass='1002' or salclass-'1003',color','other')))
You can also use match
=if(match(salclass,1009,1010),'steel',if(match(salclass,1002,1003),'color','other'))
I think the 'match' function is a best practice.
tell me using match function pls