A | B | C | |
1 | 23 | -145 | 1 |
2 | -71 | 140 | |
3 | 35 | 130 | 1 |
4 | -22 | -127 |
<tbody>
</tbody>
How do you write a proper IF(AND(OR fx in cell C1 that I can drag down thru C4 that states:
if the number in cell A1 is >0 and <50 AND
the number in cell B1 is >-150, <-109 *OR* >109, <150,
then cells C1 populates a 1 if it does, and a "" if it doesn't?
I hope I explained that ok.
The final results should have a 1 in C1 and a 1 in C3
Thanks in advance for any help!