| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
i want to base a formula off whether a checkbox is filled in
I want to use a check box and have it to base formulas i.e. if the checkbox
is filled in use this formula if notr use that formula how do i do this?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
i want to base a formula off whether a checkbox is filled in
Use a linked cell.
Then you can use a formula like: =if(a1=true,firstformulahere,secondformulahere) (A1 was my linked cell.) Josh wrote: I want to use a check box and have it to base formulas i.e. if the checkbox is filled in use this formula if notr use that formula how do i do this?? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
i want to base a formula off whether a checkbox is filled in
=IF(A1=TRUE,"box is checked","box is NOT checked")
edit A1 to where your checkbox is and the comments btw TRUE = box is checked FALSE = box is NOT checked "Josh" wrote: I want to use a check box and have it to base formulas i.e. if the checkbox is filled in use this formula if notr use that formula how do i do this?? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
i want to base a formula off whether a checkbox is filled in
=IF(A1=TRUE,Formula if box IS checked,Formula if NOT checked)
sorry, overlooked that you needed to add formulas... "Josh" wrote: I want to use a check box and have it to base formulas i.e. if the checkbox is filled in use this formula if notr use that formula how do i do this?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| ?IF function for preventing a cell being filled by formula | Excel Worksheet Functions | |||
| I have a formula that copies itself when adjacent cells are filled in. How? | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
Linear Mode
