Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Complex Formula | Excel Discussion (Misc queries) | |||
Complex If/Then formula? | Excel Discussion (Misc queries) | |||
Can someone help with this complex formula? | Excel Worksheet Functions | |||
Need Help with complex formula | Excel Worksheet Functions | |||
complex formula | Excel Worksheet Functions |