If the Second Character in A3 is _ then use X formula if not use Y formula

[ihenson25]

Sample data set below shows two separate text options within the column if the data has the _ within the cell I need to run a different formula than the ones without a _. And to avoid mistake the _ should only appear in the second character position.


[TABLE="width: 65"]
<colgroup><col width="65" style="width:49pt"> </colgroup><tbody>[TR]
[TD="width: 65"]mustangs[/TD]
[/TR]
[TR]
[TD]A_aces[/TD]
[/TR]
[TR]
[TD]badgers[/TD]
[/TR]
[TR]
[TD]panthers[/TD]
[/TR]
[TR]
[TD]bulldogs[/TD]
[/TR]
[TR]
[TD]T_aardvarks[/TD]
[/TR]
[TR]
[TD]C_Slitheren
tigers

[/TD]
[/TR]
</tbody>[/TABLE]

 

[JazzSP8]

Does this work for you?

=IF(MID(A3,2,1)="_","Forumla X","Formula Y")

 

[ihenson25]

YES... THANK you.. Thank you..