Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sumif Help Please
Hoping someone can help me out here.
I am using the following formula to calculate a recovery % in manufacturing, but the issue that I'm having is that this formula is only valid if the value in row 5 is greater than the value in row 2. Otherwise, I need to calculate the reverse, which would be row 2 value minus row 5 value. =IFERROR((SUM(SUM((D5-D2)*D4)+SUM(D19*D20))/D21),"") I basically want it to say that if D5 is greater than D2, then do the formula above, but if D5 is less than D2, I want the those cells to be swapped. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif Help Please
... the following formula ... is only valid if the value in
row 5 is greater than the value in row 2. Otherwise, I need to calculate the reverse Maybe something like this would help: =IFERROR((ABS(D5-D2)*D4 + D19*D20)/D21, "") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF and IF | Excel Worksheet Functions | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |