Forum Discussion
Returning values that are over £250 or lower than -£250 in Column S if Column R has relevant data
pedrohrmoreira Perhaps you mean something like in the attached file? If not, kindly ignore.
Riny_van_Eekelen I tried this but this will work for "overage" discrepancies over £250, but if there is a "shortage" discrepancy of -£250 or less, they will not be counted. Please advise if I'm incorrect?
pedrohrmoreira I used the ABS function to avoid plus or minus. The second row in my example has values 260 and -600. The absolute variance between the two equals 860, which is greater than 250. So, it doesn't matter if the variance is -860 or 860.
Riny_van_Eekelen thanks. It's just my organisation wanted it displayed as overages over £250 vs. shortages of less than -£250. But if I were to use your example as a workaround, how could I merge it with a COUNTIF so that I could have the discrepancy values by branch a, branch b, etc?
pedrohrmoreira Revised the schedule a little bit. Please see attached.
If you have OR condition, when you may use =COUNTIF()+COUNTIF() (or SUMPRODUCT() )
