I am looking for help with a check box formular

[Buzz Local#30]

Ok i am back and I am in need of help again

As you all know I have been working on a wage pay spread sheet for working
all around the us
so far you all have helped out bunch
well let get to it I need help with something like a check box formular
well what I want to do is have a box that will let me make a check mark in
it or something this check mark will be important what I want it to do is if
it is checked I want another cell to add a set of cells timesed by a number
in another cell but if the check mark is not in the box it will subtract
from the gross amount of my wages is this possible

 

[Dave Peterson]

Show the Forms Toolbar
(In xl2003, it's View|Toolbar, then check Forms)

Click on the checkbox and draw it on your worksheet.
Rightclick on the checkbox and select Format Control
On the Control tab, you can specify a linked cell.

Then your formula can use that linked cell to decide what to do:

(I used A1 in my example)

=if(a1=true,sum(b9:c12)*d99,x992-j15)

You'll have to change the formula to match your worksheet.

 

[Buzz Local#30]

I am using XL2007 and I can not find it in there

Show the Forms Toolbar
(In xl2003, it's View|Toolbar, then check Forms)

Click on the checkbox and draw it on your worksheet.
Rightclick on the checkbox and select Format Control
On the Control tab, you can specify a linked cell.

Then your formula can use that linked cell to decide what to do:

(I used A1 in my example)

=if(a1=true,sum(b9:c12)*d99,x992-j15)

You'll have to change the formula to match your worksheet.

 

[Dave Peterson]

From a Niek Otten post:

Office button>Popular tab, check Show developer tab in the Ribbon
Back to the worksheet:
Developer tab>Controls block>Insert>Form controls

 

[Buzz Local#30]

Ok I am sorry but I realy dont know what I am doing here I have found it and
linked it to a cell I wanted and I think I understand what formular I need
to use but when I protect my sheet it does not work and I get a error
message what do I need to do to correct this

 

[Dave Peterson]

Try unlocking the linked cell.

Ok I am sorry but I realy dont know what I am doing here I have found it and
linked it to a cell I wanted and I think I understand what formular I need
to use but when I protect my sheet it does not work and I get a error
message what do I need to do to correct this

 

[Buzz Local#30]

Kewl Thanks again guys it works great

Try unlocking the linked cell.