Excel Boolean?

Question

I am looking to create a boolean in excel in order to create a tick box. How would i do this?

Answer 1

What do you mean by "tick box?" If you mean a Check Box (like you often see in dialog boxes) then you can insert a Check Box control.

Assuming that you are using Excel 2003, Go to View --> Toolbars and turn on the Forms toolbar. Click the Check Box control and then click and drag on your worksheet where you want it to appear (you can move and resize it later, if necessary). Now, right click on the control in your worksheet and choose Format Control. There you can set the current state of the control (checked, unchecked, or mixed) and the location of the Cell Link. The cell link is the address of a cell where the control will store its current state (checked = TRUE, unchecked = FALSE, mixed = #N/A).

Once you have done that, you can make a reference to the cell link like this:

=if(Z1=TRUE,"The box is checked","The box isn't checked")

(Z1 in the example is the cell link for the control). Note that you don't need to specify the =TRUE, instead an identical formula would be:

=if(Z1,"The box is checked","The box isn't checked")

Is that what you wanted? If not, please supply some additional information.

Tim
http://www.tvmcalcs.com

Answer 2

Excel Boolean

Answer 3

Hi

View > Toolbars > Forms

Click the Checkbox control on the Forms toolbar then drag the mouse on the worksheet.

You can drag several out and then use the Group Box control to surround groups of them that change the value of a cell (right-click on one of the check boxes and choose to Format the control to set the cell that will change).

There's more about using form controls in Excel's help. Search on the term Form Controls.

-Jim Gordon
Microsoft Mac MVP

MVPs are independent and do not work for Microsoft
http://mvp.support.microsoft.com/