Need Formula for if 2 cells state a SPECIFIC value to return a 1.

[misspaulaj]

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?

 

[erik.van.geit]

Hi,

This should do that.
=IF(AND(M2="Late", N2"Late"),1, 0)
or
=--AND(M2="Late", N2"Late")

kind regards,
Erik

 

[misspaulaj]

The 1st one worked perfectly!
Thank you SOOOO MUCH! You have no clue how much this helps!

 

[misspaulaj]

Now here is my next hang up...
What I actually need is if either cell states "late" to return a 1.

How can I do that?

 

[misspaulaj]

Would this be the right formula: =IF(OR(M2="Late", N2="Late"),1, 0)

 

[erik.van.geit]

YES!
or
=--OR(M2="Late", N2="Late")

This second way of writing the formula is more for mathematicians, I guess. If you have tenthousands of formulas, you would see the difference in speed (second is faster), else don't care.

For the AND formula this is even faster, I think:
=(M2="Late")*(N2="Late")

Just a way to show you how we can approach things by different ways, sometimes thinking outside of the box