Forum Control 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!

[Cidona]

Hi ginopj.

Not achieved with an actual 'click event' but would seem to achieve what you want.

In the attached workbook the user selects the Rank in cell B2, the anwswer is returned in cell E1. You can see the formula by clicking in E1.

Hope it helps. First time posting a posible solution here