let's say i have 4 checkboxes, a, b, c, and d. i want to do some
calculation (e.g. the average) based on what is selected.

in other words, if a and b are chosen, it will be the average of a and
b. if a, b, and c are chosen, then it will be the average of a, b, and
c.

now, of course, if i hard code this as a bunch of if-then statements,
it will be cumbersome, as i'll have to code every single possible
combination (a; b; c; d; a and b; a and c; etc.).

is there a more efficient way to do this?

thanks.


--
dreamz
------------------------------------------------------------------------
dreamz's Profile: http://www.excelforum.com/member.php...o&userid=26462
View this thread: http://www.excelforum.com/showthread...hreadid=479943