If there any way that you can incorporate a tick box in to a formula, I
want something along the lines of.

If tickbox is unchecked then Sum(a1:a5), if tickbox is checked then
sum(a1:a5)/2

Is this possible?


--
blain
------------------------------------------------------------------------
blain's Profile: http://www.excelforum.com/member.php...o&userid=34368
View this thread: http://www.excelforum.com/showthread...hreadid=541467