Remember Me?

#1
November 18th 19, 05:38 PM
 Junior Member First recorded activity by ExcelBanter: Nov 2019 Posts: 1

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
November 19th 19, 10:30 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Dec 2012 Posts: 52

... 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, "")

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post silversilver Excel Worksheet Functions 2 October 16th 08 05:58 AM Harry Seymour Excel Worksheet Functions 9 June 12th 07 10:47 PM C.Pflugrath Excel Worksheet Functions 5 August 31st 05 07:31 PM dshigley Excel Worksheet Functions 5 April 5th 05 03:34 AM Oscar Excel Worksheet Functions 2 January 11th 05 11:01 PM

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