S

#### steve

I need some help,please.

I need a formula to claculate a value when input A and B are inserted. The

table below details the values I am working with and depending on the values

the results will change.

If we drew a line from 8 and 3 the yellow squares would be used in the

calculation.

Input A

1 2 3 4 5 6 7 8 9 10 11 12 36 Input A 8

2 3 4 5 6 7 8 9 10 11 12 20 Input B 3

3 4 5 6 7 8 9 10 11 12 12 Result 68

4 5 6 7 8 9 10 11 12

Input B 5 6 7 8 9 10 11 12

6 7 8 9 10 11 12

7 8 9 10 11 12

8 9 10 11 12

9 10 11 12

10 11 12

11 12

12

68

If we changed the inputs and the position of the line the following squares

would be used.

Input A

1 2 3 4 5 6 7 8 9 10 11 12 78 Input A 12

2 3 4 5 6 7 8 9 10 11 12 77 Input B 12

3 4 5 6 7 8 9 10 11 12 75 Result 650

4 5 6 7 8 9 10 11 12 72

Input B 5 6 7 8 9 10 11 12 68

6 7 8 9 10 11 12 63

7 8 9 10 11 12 57

8 9 10 11 12 50

9 10 11 12 42

10 11 12 33

11 12 23

12 12

650