Is There a Way to Convert This Logic to a Formula?

[meppwc]

Can the logic below be made into a formula?

Formula in cell U2
If S2 is blank and T2 is blank then U2 is blank
If S2 is populated and T2 is blank the map S2 to U2
If S2 is populated and T2 is populated, then map S2 to U2
If S2 is blank and T2 is populated, then map T2 to U2

 

[Joe4]

Try:

=IF(AND(S2="",T2=""),"",IF(S2="",T2,S2))

 

[Eric W]

Try:

=IF(S2="",T2,S2)&""

This assumes they are text.

 

[Fluff]

beaten 2 it

 

[meppwc]

Both work great, thanks to all

 

[snjpverma]

Try:

=IF(S2="",T2,S2)&""

This assumes they are text.

How does your formula return a blank instead of 0 when both S2 & T2 are blank?

 

[Joe4]

How does your formula return a blank instead of 0 when both S2 & T2 are blank?

Just follow the logic.

If S2 is blank, the IF part with return T2, which is blank ("") and then it concatenates another blank ("").
This second blank concatenation coerces it to text instead of numeric, so it will return a blank and not a zero.
Try it and see!

 

[snjpverma]

I tried and it works.

but when I enter this

[COLOR=#FF0000]=0&""[/COLOR]

it gives me zero as a result. why does the blank not coerce it to text in this case?
Just amazed and confused.

 

[Eric W]

I tried and it works.

but when I enter this

[COLOR=#FF0000]=0&""[/COLOR]

it gives me zero as a result. why does the blank not coerce it to text in this case?
Just amazed and confused.

Because you're giving it an actual "0". If you start with an empty cell, and add the &"", you get the empty cell, and the &"" makes sure that it's treated as text, not a number. A funny quirk of Excel is that if you do any LOOKUP function, and what you're looking up is an empty cell, Excel returns a 0. But the original cell is still empty.