8 Replies Latest reply on May 29, 2015 10:51 AM by jeff@mandalay

    Calculate Values based on which boxes are checked - for dummies...

    jeff@mandalay

      Hello, and thank you all in advance for your help. I'm trying to calculate a value based on the checkboxes selected. Specifically, I want to add a particular $$ value to each checkbox and if that box is selected, I want it to add to the total rental value (see screenshot below):

       

      Screenshot (1).png

       

      As you can see in the screenshot I have different areas that can be selected (First Floor, Front Yard, etc) I would like to assign a value to each area's checkbox (and an added value for Other) and calculate a total in the "Rental Fee Balance" minus the Security Deposit. I'm new to java and scripting but know how to do it in an excel formula. I'm assuming that this is much different from what little I know of Java. Any help you can give me would be greatly appreciated.