Hi all.
I’m trying to build a calculator/worksheet that has 12 lines.
Each line has 3 input fields: 1 for “Code”, 1 for “Value”, and 1 for “Price”.
I named each field according to its line (C1-C12, V1-V12, and P1-P12).
When the user clicks “calculate”, he/she will get a total amount for each line and a grand total at the bottom.
My problem is in dealing with the “Values” fields. If the value = 0, the line pays @ 100% of the line price. BUT if the value = 2, it has to look at every line with a “2” value, find the one with the highest price – pay that one at 100% and the rest that have “2” values @ 50%.
I can’t seem to figure out how to tie these different value fields together.
Any advice will be greatly appreciated. Thanks!!