| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tick Boxes
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Tick Boxes
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Tick Boxes
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change XY tick labels from numeric to text | Charts and Charting in Excel | |||
| count ticks in boxes | Excel Discussion (Misc queries) | |||
| Replace with single tick - formula too long.... | Excel Discussion (Misc queries) | |||
| Boxes in Forms | Excel Discussion (Misc queries) | |||
| Copying Tick Boxes | Excel Worksheet Functions | |||
Linear Mode
