Check Boxes to trigger Calculations

[ginopj]

Hello everyone. I have solved many issues by reading this forum but this is my first question. Bear with me. I am in the process of creating somewhat of a salary guide for a police department. As such there are certain constants i.e, “base salary” and certain variables, i.e., rank differential, college degree, and longevity. Now to the point. I would like to have a range of cells, lets say A1, A2, A3, and A4 which are respectively titled Patrolman (A1),Sergeant (A2), Lieutenant (A3), and Captain (A4). I would like those boxes to be “check boxes”. A user would then Check whichever rank he/she currently held. I would like that check to the trigger a calculation in another cell, say A6. If A5 held a constant “Base Salary” of for example $50,000, and a user checked the Sergeant box @ A2, the A6 cell should calculate the $50,000 plus 16%. If they checked a different box, a different calculation. This is a watered down version but a great starting point. Thank you everyone!

[Kyle123]

Assuming an ActiveX checkbox:

Please Login or Register  to view this content.

[ginopj]

Actually I prefer the Form Control check box if it's possible. Thank you for responding so quickly.

[Kyle123]

In that case you need to do something with formulas and the linked cell of the checkbox, without seeing your workbook, that's about all I can say

If you upload your workbook, I can have a look

[ginopj]

Okay. I will attempt to load the workbook. Thanks.