Check Box Formulae

[Gaffnr]

I am trying to add a formula in Excel 2003, SP3 so that something happens if
a check box or check boxes is/are ticked using a formula to show text.

i.e. if check box 1 and check box 7 are checked, show text "that is not
allowed"
etc etc.

Thanks

 

[Dave Peterson]

Assign (different) linked cells to each of the checkboxes.

Then you can test the values in the cells:

=if(and(a1=true,a7=true),"not allowed","ok")

 

[Gaffnr]

Thanks Dave. How do i assign a linked cell to a checkbox?

Im not sure I get you - please bear with my stupidity

So, checkbox is in cell A1. I link Cell A2 to it (how, as above).

How does cell A2 know if cell A1 is checked or not?

Thanks

 

[Dave Peterson]

Assigning the linkedcell is different depending on what checkboxes you used.

If you used checkboxes from the Forms toolbar, you can rightclick on each
checkbox and choose Format control, then type the address in the cell link on
the Control tab.

If you used checkboxes from the control toolbox toolbar, then go into design
mode (another icon on that toolbar), show the properties (for each checkbox) and
scroll down to LinkedCell. Type the address. Then leave design mode.

That's what a linked cell does. (It's magic!!).

Ps.

I like to use the same cell as the cell containing the checkbox. But I don't
want to see TRUE or FALSE in the worksheet.

So I give those cells a custom format of:
;;;
(3 semicolons)

I can still see the True/False in the formulabar, though.

Thanks Dave. How do i assign a linked cell to a checkbox?

Im not sure I get you - please bear with my stupidity

So, checkbox is in cell A1. I link Cell A2 to it (how, as above).

How does cell A2 know if cell A1 is checked or not?

Thanks

 

[Gaffnr]

Dave Peterson - you are a genius!!
Thanks so much - it works like a dream.
Rob

 

[Dave Peterson]

Glad you got it working.

Dave Peterson - you are a genius!!
Thanks so much - it works like a dream.
Rob