I am trying to write an IF statement with two requirements. I have a date
column and a text column. I would like the formula to give an end result of
"1" if the date cell is greater than a certain month AND if my text cell
equals a certain word. Can this be done?

Hi!

You haven't defined what you want if those conditions are
false.

These will return 1 if true and 0 if false:

=(MONTH(A1)5)*(B1="word")

=--AND(MONTH(A1)5,B1="word")

This one will leave the cell blank (not empty) if false:

=IF(AND(MONTH(A1)5,B1="word"),1,"")

Biff

-----Original Message-----
I am trying to write an IF statement with two
requirements. I have a date
column and a text column. I would like the formula to
give an end result of
"1" if the date cell is greater than a certain month AND
if my text cell
equals a certain word. Can this be done?
.

One way.
Date column is A, and text column is B,
And with your criteria date in D1, and your criteria text in E1, try this:

=--AND(MONTH(A1)MONTH($D$1),B1=$E$1)
And drag down to copy as needed.

This returns ones and zeroes.

If you'd rather have ones and *empty* cells, try this:

=IF(AND(MONTH(A1)MONTH($D$1),B1=$E$1),1,"")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Matt" wrote in message
...
I am trying to write an IF statement with two requirements. I have a date
column and a text column. I would like the formula to give an end result
of
"1" if the date cell is greater than a certain month AND if my text cell
equals a certain word. Can this be done?

THANK YOU VERY MUCH!!!!!!! That was almost two hours of me ramming my head
in the wall because I couldn't figure it out. I kept trying to use
@IF(and(..... statements, but either they wouldn't work, or they worked a
different way so I kept thinking it was something that I didn't add.
Anyways. Thanks again for helping me with this!!

"Ragdyer" wrote:

One way.
Date column is A, and text column is B,
And with your criteria date in D1, and your criteria text in E1, try this:

=--AND(MONTH(A1)MONTH($D$1),B1=$E$1)
And drag down to copy as needed.

This returns ones and zeroes.

If you'd rather have ones and *empty* cells, try this:

=IF(AND(MONTH(A1)MONTH($D$1),B1=$E$1),1,"")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Matt" wrote in message
...
I am trying to write an IF statement with two requirements. I have a date
column and a text column. I would like the formula to give an end result
of
"1" if the date cell is greater than a certain month AND if my text cell
equals a certain word. Can this be done?

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Matt" wrote in message
...
THANK YOU VERY MUCH!!!!!!! That was almost two hours of me ramming my
head
in the wall because I couldn't figure it out. I kept trying to use
@IF(and(..... statements, but either they wouldn't work, or they worked a
different way so I kept thinking it was something that I didn't add.
Anyways. Thanks again for helping me with this!!

"Ragdyer" wrote:

One way.
Date column is A, and text column is B,
And with your criteria date in D1, and your criteria text in E1, try
this:

=--AND(MONTH(A1)MONTH($D$1),B1=$E$1)
And drag down to copy as needed.

This returns ones and zeroes.

If you'd rather have ones and *empty* cells, try this:

=IF(AND(MONTH(A1)MONTH($D$1),B1=$E$1),1,"")

--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-

"Matt" wrote in message
...
I am trying to write an IF statement with two requirements. I have a
date
column and a text column. I would like the formula to give an end
result
of
"1" if the date cell is greater than a certain month AND if my text
cell
equals a certain word. Can this be done?