Ok, I have had great results on my two previous IF fx posts, but this one is a humdinger. Let's see which one of you Excel masters can help me out.
A B C D
1. 2, -11, 9
2. -6, -8, 22
3. 7, 17, 19
4. -25, -1, 5
In cell D1, I need a IF(OR(AND fx that calculates the following:
If B1 is less than or equal to -10,
OR if B1 is less than or equal to -7 AND A1 is greater than or equal to -10 AND less than or equal to 10,
OR if C1 is greater than or equal 10 AND B1 is greater than or equal to 10 AND A1 is greater than or equal to -10 AND less than or equal to 10, then cell D1 should read "1", if not, D1 should be blank.
In the above example, D1 should have a "1", D2 should have a "1", D3 should have a "1", and D4 should be "blank".
I can barely walk in a straight line, so if anyone can figure this one out, I would be most appreciative.
Thanks in advance!
Bookmarks