Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Column C has numeric values
Column F has numeric values Column M has numeric values What I would like to do somthing like the following: =SUMPRODUCT(MIN(C10:C21,(1099.41-F10:F21)),M10:M21) In English - subtract each value in column F from 1099.41, come up with a stream of 12 numbers compare these twelve numbers to the 12 numbers in column C and use the lessor (by row) and multiply this result by the values in M10:M21 (if the lessor of the two number is negative , zero will be used) Example Column C Column F 100 100 .08 100 200 .08 100 300 .085 100 400 .085 100 500 .085 100 600 .095 Subtracting 100 from 1099.91 = 999.91 compare that to 100 the lessor of the 2 is 100. Multiply number by .08 to yield 8 The final number would compare 99.91 to 100 the lessor of the 2 is 99.91. Multiply this number by .095 to yield 9.49 The number in column C will not always be constant but Column F will always be the sum of column C. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sumproduct calculation between two workbooks | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |