Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Coding Checkboxes

  Asked By: Bertha    Date: Feb 26    Category: MS Office    Views: 679
  

I have been working with the checkboxes as you had suggested. For the most part
it is working. I have one issue. Some of the questions on my palm pilot can have
more than one answer. When more than one is chosen, the data returned to that
cell is as follows:
1|2|4|6
Is there an easy way to break this out into four cells so that the four
associated checkboxes can be activated?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Kellie Bishop     Answered 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.

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




Tagged: