Writing a statement counting multiple columns

[datadummy]

I need help writing a statement that essentially says if column A is the month of December in the following format xx/xx/xxxx. Then if column B has a number that starts with 23, 24, 25. Then if column O is Y or N.

 

[DanteAmor]

Use the following formula

Cell	Formula
P2	=IF(AND(MONTH(A2)=12,OR(LEFT(B2,2)="23",LEFT(B2,2)="24",LEFT(B2,2)="25"),OR(O2="Y",O2="N")),"Match","NO Match")

<tbody>
</tbody>

Test and tell me.

 

[datadummy]

It doesn't seem to be working, here is my formula
=IF(AND(MONTH(A23)=12,OR(LEFT(B23,2)="23",LEFT(B23,2)="24",LEFT(B23,2)="25"),OR(O23="Y",O23="N")),"Y","N")
The data in the cells referenced is as follows
A2=12/4/2018
B2=237-1
O2=N
The equation is yielding a Y result when it should be an N.Please let me know if I have entered something incorrect.

 

[DanteAmor]

Let's see

=IF(AND(MONTH(A23)=12,OR(LEFT(B23,2)="23",LEFT(B23,2)="24",LEFT(B23,2)="25"),OR(O23="Y",O23="N")),"Y","N")


A23=12/4/2018 Month = 12 Result = Yes
B23=237-1 left("237-1",2) = 23 Result = Yes
O23="N" N=N Result = Yes


We have 3 yes then the result is Y. If we had less than 3 yes then the result is N.

Or maybe I did not understand what the conditions are for getting Y

 

[datadummy]

So the first 2 points are accurate of yielding a Y but if column O has an N in it then I need the result to be an N,but if column O has a Y in it then the result should be Y

 

[DanteAmor]

I need help writing a statement that essentially says if column A is the month of December in the following format xx/xx/xxxx. Then if column B has a number that starts with 23, 24, 25. Then if column O is Y or N.

It says if column O is "Y" or "N".

Then it should be, if column O is "Y"

Test:

=IF(AND(MONTH(A23)=12,OR(LEFT(B23,2)="23",LEFT(B23,2)="24",LEFT(B23,2)="25"),O23="Y"),"Y","N")

 

[datadummy]

Ok that one did the trick. Thanks!!

 

[Rick Rothstein]

=IF(AND(MONTH(A23)=12,OR(LEFT(B23,2)="23",LEFT(B23,2)="24",LEFT(B23,2)="25"),O23="Y"),"Y","N")

You can shorten your formula slightly...

=IF(AND(MONTH(A2)=12,OR(LEFT(B2,2)={"23","24","25"}),O2="Y"),"Y","N")

 

[datadummy]

Would it be possible to attempt a wrap up statement that would say something like if column A = the month of December in this format xx/xx/xxxx and if column B has the 23,24,25 in them and then if column O is Y.

 

[Rick Rothstein]

Would it be possible to attempt a wrap up statement that would say something like if column A = the month of December in this format xx/xx/xxxx and if column B has the 23,24,25 in them and then if column O is Y.

Why are you trying to force the "in this format xx/xx/xxxx"? Dates in Excel are just whole numbers (the count of days since "day 0"... the day before January 1, 1899), what you see in the cell is for human convenience... Excel does not use it.