If a cell contains certain data, how to get different answers?
Hi,
I am trying to get Cell R23 to look at Cell A23, and if A23 contains the text "JACK", the word "CORRECT" goes into R23, if Cell A23 contains any other text/value other than "JACK" for R23 to read "WRONG" but if A23 is blank then R23 to be left blank.
I have tried this formula unsuccessfully; =IF(A23,"*JACK*","CORRECT","WRONG",>0,"")
Any suggestions would be most welcome.
Thanks
=IF( A23 = "", "" , IF( SEARCH("jack",A23,1), "CORRECT","WRONG"))
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi Wayne,
Many thanks for the help. It nearly works. If A23 is blank then R23 is blank. Good. If A23 = "JACK" then R23 = "CORRECT". Good.
Only issue is when A23 is say "FRED" or "JAKE" then instead of R23 stating "WRONG" it is reading #VALUE!
Is it something I have done wrong?
my bad
try
=IF( A23 = "", "", IF( ISNUMBER(SEARCH("jack",A23,1)), "CORRECT","WRONG"))
Thank you Wayne, you are a genius!
So glad I came to this forum for such kindness to help others.
Kind regards
Brian
you are very welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks