Excel Check Box problem

[ajw150]

Hi,

I am new to this forum, but in desperate need of some Excel help.

I have created a long series of questions and the answers are in th
form of "check boxes". If the user clicks the YES checkbox to
questions I want to be able to "add" them up, and come up with
result, i.e ANSWER. If the user clicked 3 YES and 1 NO, I want
different answer to appear.

I am not too sure if I am on the right track, as so far I was wonderin
if I need to give the TRUE a number and so on?

Hope this message is not too confusing. Hope you know what I mean.


The new example should help. If there are alternative ways to solve th
problem please let me know.

Thank

Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=50359

 

[Frank Kabel]

Hi
if you link your checkboxes to a cell you could count these cells with
COUNTIF. Though not sure what kind of answers you expect based on the
checkboxes

 

[Max]

Set-up the Cell links to the checkboxes in C2:E6
in a corresponding range say, C11:E15

Checkboxes in C2:C6 will link to cells C11:C15,
with those in D26 linked to D1115, and so on

Steps to do the Cell link
-----------------------------
Example: For the checkbox named "Defined" in C2

Right-click > Format Control > Control tab
Put in the Cell link: $C$11
(or just click inside the cell link box, then click on C11)

Click OK

Repeat to link all the other checkboxes to their respective Cell links

-------
Usage
-------
Taking your example:

You want a result of "Action" (and "No Action" if otherwise)
if the user clicks the checkboxes (i.e. "checks" the checkboxes) named:
Defined, Pro, Amendment1, Minor & Compliance
which are linked to cells: C11,C14,D15,E12,E13 respectively

Put in say, A8: =IF(AND(C11,C14,D15,E12,E13),"Action","No Action")

If *all* the checkboxes with linked cells in C11,C14,D15,E12,E13 are
checked,
AND(C11,C14,D15,E12,E13) will evaluate to TRUE,
and A8 will return "Action"

Repeat similarly as done for / in result cell A8,
to set-up all other desired combinations of checkbox statuses in other
result cells

Hide away the rows 11:15 (i.e. all the cell links) and you're all set !

 

[Bob Phillips]

or you could use a different technique as described here
http://tinyurl.com/g1my and just COUNTA the range(s) of cells

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Hi
if you link your checkboxes to a cell you could count these cells with
COUNTIF. Though not sure what kind of answers you expect based on the
checkboxes

 

[ajw150]

Many thanks Max. I seem to understand now. Any further help would b
great. ajw150(at)hotmail(dot)com.

Andre

 

[Max]

You're welcome, Andrew !
Thanks for the feedback.

I'll send the file to your id,
once yahoo mail is up
(it's sort of hung up right now, not accessible)

 

[ajw150]

Hi,

Now, how do I make it produce a result depending on a various selectio
of boxes checked

 

[Max]

As per the example construct given,
one way is to use IF() formula in combination with AND() or OR()
to read the Cell link values of the boxes.

The values in the Cell Links' range C11:E15 would be either TRUE or FALSE,
depending on the corresponding box statuses, viz.:
"checked" boxes = TRUE or "unchecked" boxes = FALSE

AND() can be used to gather the result from a selection of particular boxes
checked
and ensure that it evaluates to TRUE only if the particular selection is
made.

 

[Max]

File sent, Andrew !

 

[ajw150]

Thanks.

Its a tough one for me!

Andre

 

[Max]

Essential concept is to grab the outputs from the cell links
(Each check box is linked to a particular cell link)

And then use / evaluate these outputs via formulas for the desired results

Give it a try. Once you get the hang of it, it won't seem so tough <g> ..

 

[Max]

Essential concept is to grab the outputs from the cell links
(Each check box is linked to a particular cell link)

And then use / evaluate these outputs via formulas for the desired results

Give it a try. Once you get the hang of it, it won't seem so tough <g> ..