Almost works!

To link the text box, right click it and then select Format Control and then
the tab Control and select a cell in cell link.

The formula should then be:

=IF(D1=TRUE,SUM(A1:A5)/2;SUM(A1:A5))

HTH

Ian

"Ardus Petus" wrote:

You must link your textbox to some cell (say D1) that will automatically
switch from FALSE to TRUE when the checkbox is ticked.

Then you can use a formula like:
IF(A1SUM(A1:A5)/2;SUM(A1:A5)

HTH
--
AP

"blain" a écrit dans le
message de news: ...

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