Thread
:
Tick Boxes
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
Posts: n/a
Tick Boxes
Booooooh: I did not test, nor re-read my formula!
Shame on me!
--
AP
"Ian P" a écrit dans le message de news:
...
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
Reply With Quote