Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I enter a working check box option in Excel?
I am trying to insert a "check the box" option in Excel and then use an "if
checked, then do xxx" formula to calculate various sales projections based on which mix of product lines are checked. I am able to insert the Wingding character that looks like the check off box, but it just sits there like clip art with no functionality, so I am either not taking it far enough or just going about it all wrong. I am using several different versions of Excel to do this project depending on where I am at the time (home, work, laptop) so I can set it up in whichever is easiest. |
#2
|
|||
|
|||
Hey Lisa,
You need to create a check box control (actually looks like a tick box) from the Forms toolbar. Once you create the check box you must Format Control (RM click on check box) and nominate a Cell link (a "holding cell", e.g. A1) this allows XL to record whether it is ticked by placing True in the cell link(A1) or not ticked by placing False in the cell link. you can then run your If statement based on the return in the cell link, e.g., =IF(A1=True,B1*C1,"") (B1, C1 and "" to be replaced with your formula) the cell link can be on another sheet and hidden if necessary. cheers, Nadia "Lisa the CPA" wrote: I am trying to insert a "check the box" option in Excel and then use an "if checked, then do xxx" formula to calculate various sales projections based on which mix of product lines are checked. I am able to insert the Wingding character that looks like the check off box, but it just sits there like clip art with no functionality, so I am either not taking it far enough or just going about it all wrong. I am using several different versions of Excel to do this project depending on where I am at the time (home, work, laptop) so I can set it up in whichever is easiest. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Office 97 to 2003: Excel: enter data w/fixed 2 decimal. 2000. be. | New Users to Excel | |||
Office 97 to 2003: Excel: enter data w/fixed 2 decimal. 2000. be. | New Users to Excel | |||
Enter Data Into Another Excel File Automatically | Excel Worksheet Functions | |||
Why does spelling check close Excel when checking spanish? | Excel Discussion (Misc queries) |