misspaulaj
New Member
- Joined
- Feb 4, 2014
- Messages
- 14
I have two columns that return the phrases of "Late" and "Not Late" in Column M & N (based on two different formulas).
I am looking for a formula that will read the text and return a value of "1" ONLY if it both cells in M & N states "Late".
Anyone know of anything? Basically what I want the cell to do is this:
IF(M2="Late"&N2"Late",1, 0)
If $M2 says late & $N2 says late, return a 1 if they do not say "late" return a 0.
Any Ideas?
I am looking for a formula that will read the text and return a value of "1" ONLY if it both cells in M & N states "Late".
Anyone know of anything? Basically what I want the cell to do is this:
IF(M2="Late"&N2"Late",1, 0)
If $M2 says late & $N2 says late, return a 1 if they do not say "late" return a 0.
Any Ideas?