Hi,

I am creating a model that has 4 inputs (input 1, input 2, etc). On
the column next to each input, I have set up check boxes. What I would
like to do is: Depending on what combination of boxes are checked or
unchecked, I would like like the next column to show a predetermined
weighting figure.

For example, if all 4 boxes are checked off, I would like the
respective weightings on the next column to show 15,30,35,20. If say,
only box one and box three was checked off, it would show 20, 80. If
only Box one and two were checked off, it would show 25,75. And so
on..

With all the potential permutations, what would be the best way to do
this? I've set up a grid on a separate worksheet to show what
weightings are to be assigned depending on what items are checked off
but I'm not sure how I can tie this in ..

Hope its not too confusing!

Thanks


--
inoexcel
------------------------------------------------------------------------
inoexcel's Profile: http://www.excelforum.com/member.php...o&userid=33055
View this thread: http://www.excelforum.com/showthread...hreadid=528699