Formula Editor
Hi, I'm trying to write a formula that will check if the values in Column A & Column B are both over zero OR if the values in Column C & Column D are both over zero (and so on with many column pairs). If at least one pair has both values over zero, I would like the formula to return 1. If not, return 0. However, the formula I wrote is returning all 1's... even in rows that have all negative num...