How can I associate a formula with Checkboxes
If you use linked cells for each of those checkboxes, you could refer to those
linked cells.
Say you linked to A1:A4 (UN, NI, AE, EE respectively).
=a1*1 + a2*2 + a3*3 + a4*4
The linked cells will be true or false.
True * a number = that number.
False * a number = 0
Todd Nelson wrote:
Is it possible that I can associate a formula along with check boxes.
example: There are four check boxes UN, NI, AE, & EE. If UN is selected it
is worth 1 point, NI worth 2pts etc.?
--
Dave Peterson
|