I'm setting up a series questions that are answered yes/no by ticking a
checkbox.

Is it possible to assign a different value to each checkbox so I can produce
a 'final' value based on the boxes checked?

(I'm trying to 'wieght' the answers given, in order to assign a final 'score')

Many thanks in adavnce of any reply!

Link your checkboxes to cells (for example 3 checkboxes linked to A1, A2 and
A3 respectively).
In A4, create a formula to weigh the values.
example: =(a1*.4)+(a2*.5)+(a3*.1)
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Sucram" wrote:

> I'm setting up a series questions that are answered yes/no by ticking a
> checkbox.
>
> Is it possible to assign a different value to each checkbox so I can produce
> a 'final' value based on the boxes checked?
>
> (I'm trying to 'wieght' the answers given, in order to assign a final 'score')
>
> Many thanks in adavnce of any reply!

"Sucram" <(E-Mail Removed)> schrieb im Newsbeitrag
news:418B4C2D-8001-4C02-9A8C-(E-Mail Removed)...
> I'm setting up a series questions that are answered yes/no by ticking a
> checkbox.
>
> Is it possible to assign a different value to each checkbox so I can produce
> a 'final' value based on the boxes checked?
>
> (I'm trying to 'wieght' the answers given, in order to assign a final 'score')
>
> Many thanks in adavnce of any reply!



Using the Tag property of the checkbox would be a solution.

HTH.

Helmut.