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.

mustangs

A_aces

badgers

panthers

bulldogs

T_aardvarks

C_Slitheren tigers

<colgroup><col width="65" style="width:49pt"> </colgroup><tbody>
</tbody>

 

[JazzSP8]

Does this work for you?

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

 

[ihenson25]

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