I am looking for help with a check box formular
 

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

I am looking for help with a check box formular
 

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 looking for help with a check box formular
 

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

I am looking for help with a check box formular
 

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

I am looking for help with a check box formular
 

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

I am looking for help with a check box formular
 

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

I am looking for help with a check box formular
 

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