View Single Post
  #1   Report Post  
Alisha V Alisha V is offline
Junior Member
 
Posts: 1
Default 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.