Probably a simple solve, but I'm doing something wrong on my spreadsheet.
Here's the scenario:
--E--AX--AY
1 -5, 10, 1
2 4, -12, 1
3 12, 6,
4 -14, 7,
I need an IF(AND formula that illustrates that if cell AX1 is greater than or equal to 9 but less than 20, or less than or equal to -9 and greater than -20, AND cell E1 is between 9 and -9, then cell AY1 has a "1" in it. If these conditions aren't met, it returns a " ".
Here is how I wrote it, and it's not working.
=IF(AND(AX1>=9,AX1<20,AX1<=-9,AX1>-20,E1>=-9,E1<=9),"1","")
Maybe I need an IF(AND(OR formula...?
Any help would be appreciated. Thanks.
Bookmarks