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 wrote:

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

--
Rob Gaffney

--

Dave Peterson