Payment Calculations

[rdr910]

Hey everyone I'm looking for some help. I am trying to setup a calculation that will get me an output of total payment to our customers. I would like to enter the zip code of the region from where the customer is from and then have that pull up the average amount of money for the county in the U.S. (I have completed this part).

Then I would like to enter a misc field for Yes/No answer. If the answer is yes, I want to cancel out step one and then enter the new average from another category of averages. Then have another field to enter a number "1 to 100". I want this number to be multiplied automatically by $5.15. Then this answer to be added onto the averages.

Can anyone give me any help! It would be appreciated!

[zbor]

Can you upload example workbook?

[rdr910]

I have uploaded an example spreadsheet with all the categories in the spreadsheet. I also created a form on how i would like the numbers/answers to be inputed.