I want to create a formula in each row of Column B. The forumla should be: If the cell in Column A appears any "ABC" among the 9 alpthabet/figures, then show "Accept" in Column B, or else "Decline". Can anyone help me?
Column A Column B
Row1 2400ABC88 Accept
Row2 320CDE114 Decline
Row3 13570ABC4 Accept
Row4 13ABC2350 Accept
Row5 240DEF115 Decline
Kelvin
Bookmarks