A | B | C | D |
10,000 | 400 | 23,000 | 2,498 |
50,000 | -1325 | 26,000 | 57 |
20,000 | 505 | 37,000 | -104 |
30,000 | -8,000 | 21,000 | -1,035 |
17,000 | 6,032 | 14,000 | 2,045 |
<tbody>
</tbody>
Hi All,
How can I write an If statement that scans all of Column B and Column D looking for any results that are BOTH less than -4,000 AND less than -4% of the corresponding value immediately to its left? (Example: the 4th value in the B column would be the only result that would satisfy both criteria, because -8,000 is less than -4,000 AND -8,000 is less than -4% of 30,000.
Thanks so much for the help - this forum is incredible.
-A