is there a way to do somthing like this IF(M35="yes*" I want a few levels of yes yes-somthing yes-somthingelse no
one cell will only care about the yes so if possible id rather just get a wildcard in there so I dont have to add extra layers of if statements
Thanks
You can't use a wildcard in a direct comparison like that but if you want to check whether M35 starts with "yes" you can use LEFT, e.g.
=IF(LEFT(M35,3)="Yes",TRUE,FALSE)
or COUNTIF with a wildcard
=IF(COUNTIF(M35,"Yes*"),TRUE,FALSE)
Audere est facere
ok, Thank you for the quick answer
and maybe with search??
=IFERROR(IF(SEARCH("*yes*",D19,1)=1,"yes there is"),"no sorry")
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks