1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • Sumif Help Please

    From MyVeryOwnSelf@21:1/5 to All on Tue Nov 19 14:30:35 2019
    ... 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, "")

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)