Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Bertha Ferguson   on Feb 26 In MS Office Category.

  
Question Answered By: Kellie Bishop   on Feb 26

=NOT(ISERROR(FIND(1,E5)))

Will find if there is a 1 in cell E5. It gives true if there is and false
if there is not.

You have to use Find because the number may not always be in the same
position. Find returns an error if the string it is looking for is not in
the target string.

This will only work if there are 9 or fewer options for a particular group.
Otherwise, it would find 2 if 12 was ticked. There is a way around this but
the formula would be more complicated. You could make it
=NOT(ISERROR(FIND("|1|","|" & E5 & "|")))

I am sure you can adapt this to suit your application.

Share: 

 
 
Didn't find what you were looking for? Find more on Coding Checkboxes Or get search suggestion and latest updates.


Tagged: