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.
|