Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
IF I want to do this:
IF(city='A' or city='B' or city='C' or ..., type=1,type=2)
Do I have to write the formula with multiple "or" function? Is there an easier way to do that?
You can use Match(). Like:
If(Match(City, 'A', 'B', 'C'), City)
It really works. Thx