I am looking for help with a check box formular

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Buzz Local#30 - 19 May 2008 22:56 GMT

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

Reply to this Message

Dave Peterson - 20 May 2008 00:25 GMT

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.

> Ok i am back and I am in need of help again
>
[quoted text clipped - 7 lines]
> 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

Signature

Dave Peterson

Reply to this Message

Buzz Local#30 - 20 May 2008 01:23 GMT

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)
[quoted text clipped - 26 lines]
>> 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

Reply to this Message

Dave Peterson - 20 May 2008 01:37 GMT

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

> I am using XL2007 and I can not find it in there
>
[quoted text clipped - 32 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

Buzz Local#30 - 20 May 2008 02:02 GMT

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

> From a Niek Otten post:
>
[quoted text clipped - 42 lines]
>> >
>> > Dave Peterson

Reply to this Message

Dave Peterson - 20 May 2008 02:26 GMT

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
[quoted text clipped - 51 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

Buzz Local#30 - 20 May 2008 03:05 GMT

Kewl Thanks again guys it works great

> Try unlocking the linked cell.
>
[quoted text clipped - 57 lines]
>> >
>> > Dave Peterson

Reply to this Message