I am looking for help with a check box formular

B

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
 
D

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.
 
B

Buzz Local#30

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

Dave Peterson said:
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.
 
D

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
 
B

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
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top