Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
repost: Min/Max help needed with a SumProduct | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |