How can I associate a formula with Checkboxes

T

Todd Nelson

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.?
 
D

Dave F

Probably, with some VBA coding. But what do the checkboxes get you that
putting the values in a cell don't?

I.e., a formula like =IF(A1="UN",1,IF(A1=NI,2,...))

Dave
 
D

Dave Peterson

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
 
Top