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
|