I am asking for assistance with a formula that will check if data in two separate columns meets a certain criteria, and depending on the outcome will show 1 for positive (i.e meets both criteria) or 0 for negative (i.e does not meet both criteria).
My data:
Column A contains 1 or 0
Column B contains a range of different values (approx 1 to 800)
Required Formula:
In column C, I would like a formula that will display "1" if value in Col A = 1 and value in Col B is greater than 60, otherwise display "0" (i.e. if col A is 0, or Col B is less than 60)
Thanks in advance
Bookmarks