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

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

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

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

"Dave Peterson" wrote in message
...
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 wrote:

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

From a Niek Otten post:

Office buttonPopular tab, check Show developer tab in the Ribbon
Back to the worksheet:
Developer tabControls blockInsertForm controls




Buzz Local#30 wrote:

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

"Dave Peterson" wrote in message
...
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 wrote:

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

--

Dave Peterson

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" wrote in message
...
From a Niek Otten post:

Office buttonPopular tab, check Show developer tab in the Ribbon
Back to the worksheet:
Developer tabControls blockInsertForm controls




Buzz Local#30 wrote:

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

"Dave Peterson" wrote in message
...
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 wrote:

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

--

Dave Peterson

Try unlocking the linked cell.



Buzz Local#30 wrote:

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" wrote in message
...
From a Niek Otten post:

Office buttonPopular tab, check Show developer tab in the Ribbon
Back to the worksheet:
Developer tabControls blockInsertForm controls




Buzz Local#30 wrote:

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

"Dave Peterson" wrote in message
...
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 wrote:

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

--

Dave Peterson

--

Dave Peterson

Kewl Thanks again guys it works great

"Dave Peterson" wrote in message
...
Try unlocking the linked cell.



Buzz Local#30 wrote:

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" wrote in message
...
From a Niek Otten post:

Office buttonPopular tab, check Show developer tab in the Ribbon
Back to the worksheet:
Developer tabControls blockInsertForm controls




Buzz Local#30 wrote:

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

"Dave Peterson" wrote in message
...
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 wrote:

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

--

Dave Peterson

--

Dave Peterson