Afternoon,
I am struggling with the If function. I am trying to look into cell A2, and if the values C+,B-,B,B+,A-,A,A+ or A* are present are want it to return True or Yes, and if not False or No.
Any help would be gratefully appreciated.
Thanks
Afternoon,
I am struggling with the If function. I am trying to look into cell A2, and if the values C+,B-,B,B+,A-,A,A+ or A* are present are want it to return True or Yes, and if not False or No.
Any help would be gratefully appreciated.
Thanks
Last edited by Cmorgan; 05-20-2014 at 08:46 AM.
Hi,
maybe
Please Login or Register to view this content.
in order to get TRUE or FALSE
Regards
Last edited by canapone; 05-20-2014 at 07:23 AM. Reason: OR
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Hi again,
more or less same formula in order to get "YES" or "NO"
Hope it helpsPlease Login or Register to view this content.
you could also try in B1
=SUMPRODUCT(--(A1={"C+";"B-";"B";"B+";"A-";"A";"A+";"A*"}))>0
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
you could also try in B1
=SUMPRODUCT(--(A1={"C+";"B-";"B";"B+";"A-";"A";"A+";"A*"}))>0
or go to formula tab--> Name manager ---> new name ---> give new name as List
and in the source copy paste ={"C+";"B-";"B";"B+";"A-";"A";"A+";"A*"}
then use =SUMPRODUCT(--(A1=list))>0
Hi,
Sample.xlsx
I think will be more easy.
Punnam
Many thanks.
You are welcome and Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks