Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 18th 19, 06:38 PM
Junior Member
 
First recorded activity by ExcelBanter: Nov 2019
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.

  #2   Report Post  
Old November 19th 19, 11:30 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2012
Posts: 49
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUMIF and IF silversilver Excel Worksheet Functions 2 October 16th 08 05:58 AM
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" Harry Seymour Excel Worksheet Functions 9 June 12th 07 10:47 PM
Embedding a Sumif in a sumif C.Pflugrath Excel Worksheet Functions 5 August 31st 05 07:31 PM
nested sumif or sumif with two criteria dshigley Excel Worksheet Functions 5 April 5th 05 03:34 AM
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function Oscar Excel Worksheet Functions 2 January 12th 05 12:01 AM


All times are GMT +1. The time now is 02:31 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017