Example:
A, B, C
1 3, 8
2 -2, -8
3 7, -7
I am trying to write a function for a spreadsheet that calculates the following:
If A1 is greater than 0 but less than 6 AND B1 is greater than or equal to 6, OR of A1 is less than zero AND B1 is less than zero, then in C1, I would want a "1" displayed, and if neither of the rules apply, I would like for C1 to be kept blank.
So in the example above, both C1 and C2 should read "1", whereas C3 should be blank.
Thanks in advance for your help!
Bookmarks