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!
Bookmarks