View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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