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

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?
 
Hi,

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

kind regards,
Erik
 
Upvote 0
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?
 
Upvote 0
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 :-)
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top