For example, I want to change the cell A1 to "yes" when B1 value contain the string "abc".
How to make it ?
For example, I want to change the cell A1 to "yes" when B1 value contain the string "abc".
How to make it ?
Hi,
Try this:
Cheers![]()
=if(b1="abc","yes","")
![]()
hi
or if you want to return yes if A1 includes abc (eg 12345abcde) try this
![]()
=IF(ISERR(FIND("abc",A1)),"no","yes")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks