Multiple URL in single field

[tango]

Hi,

I am creating a URL for a specific field in Straight table through add link and then pasting the URL.

I have a requirement wherein I am suppose to represent 3 different links for that specific field like : If I have a field called ID so if(ID =1,'https://abc.com',

If(ID =2,'https://qwe.com,'https://asd.com'))

Can I add multiple links like this by using If?

Any advise will be great help!

[Or · Accepted solution]

I don't see why not, assuming each cell has a single URL associated with it.

[tango]

Yes, but IF doesnot work in this. Any other way ?

[Or]

If() does indeed work this way:

=if(Dim2=1,'http://google.com','http://bing.com')

[tango]

So 3 different links for 3 IDs but same field.

[Or]

That doesn't look like a valid if() statement.

[tango]

Sorry , I corrected it ,Thanks. That works. 

But what in case if I have string values

Can you please help me with this , like using wildmatch and then the links

[Or]

Same thing, just a different If() statement. It doesn't matter if the ID is numeric or string, and it doesn't matter if you use ID = 1 or Match(ID,1).

[tango]

Actually I have something like this

ABC124

ABC345

BCV111

BCV567

QWERTY900

QWERTY220

so for 

[tango · Accepted solution]

Got it sorted
=If(WildMatch(ID,'QW*'),'https://www.yahoo.com',
if(WildMatch(ID,'A*'),'https://www.google.com','wikipedia.com'))