Forum Discussion
Returning values that are over £250 or lower than -£250 in Column S if Column R has relevant data
Pedro, what do you mean under higher? Every number which is higher than +250 is also higher than -250. -100 is higher than -250 and -500 is less than -250.
Hi Sergei,
Sorry, I wrote that completely incorrectly. Let me explain it again and hopefully this time without making it sound confusing.
For e.g. Column A is what the value should be based on paperwork and Column B has the actual value. If Column A has a value of £1,000 and then Column B has another value of £1,500, then this means we have an "overage" discrepancy of £500, meaning it is over our £250 threshold. I would therefore want my formula to return this as 1 count of discrepancy that is over the £250 threshold.
I would also want the formula to return a "shortage" discrepancy that is less than the -£250 threshold (i.e. if the discrepancy was -£500 based upon Column A having £0, but Column B having -£500).
I hope this explains it better?
