If neither

[ExcelNooberino]

Hello all, hope you're doing fine..

So I made this dashboard with some data I insert every once and a while, and in the table that contains all that data I have two columns stating the some locations. It's a simple table where I insert the pickup location in one column and the delivery location in the next one, and on the third one, I have an IF formula that tells me that if the pickup location is for example "Miami" in the third column it will return me the value "Outbound" and if not it will return "Inbound". The thing is that some times, I arrange some transportation from point A to B and neither of them are my company so, it those cases it doesn't make sense label them as "Inbound" or "Outbound". I was wondering if there's any formula that allows me to state that if neither of those columns have the value "Miami" it should return a different value such as "XBound" for example... I hope I made my question clear, but if not I can try to explain myself a little better. For now I have this:

Data.Cells(row, 10).Formula = "=IF(H" & row & "=""Miami"",""Outbound"",""Inbound"")" 'Bound

Thanks in advance

 

[Yongle]

This is the formula you need to convert to VBA

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

H​

[/th][th]

I​

[/th][th]

J​

[/th][th]

K​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]From[/td][td]To[/td][td]Label[/td][td] Formula[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td]Miami[/td][td]New York[/td][td]OutBound[/td][td] =IF(H5="Miami","OutBound",IF(I5="Miami","InBound","Xbound"))[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td]New York[/td][td]Miami[/td][td]InBound[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]Houston[/td][td]New York[/td][td]Xbound[/td][td][/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: SheetXX[/td][/tr][/table]

 

[ExcelNooberino]

Thanks man, you are a savior :D