Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have requirement like below
1 one2 two3 three4 four5 fiveupdateNo update
I need to create one filter like
If -1 one,2 two,3 three---10+
if - 2 two,3 three-20+
If -3 three, 4 four, 5 five-30+
Please let me know how I can write expression and I am trying like below expression. But its not giving 20+
if(Match(filed,'1 one','2 two','3 three') ,'10+',if( Match(filed,'2 two','3 three'),'20+'))
Regards,
Siva