About Us

NISMOJim

I am working in Excel 2003, and am new to programming in Excel.
Column A is an imported date (mm/dd/yyyy), Column B is the same date (=A1 formatted as mmm) so that any year will work the same, and column C is text. In column D I want a statement something like this:
=IF(B1="Apr" AND C1="Joe",1,0).
Of course, this isn't working, even though it looks to me like it should. What am I missing? Any help with how to get this working as expected would be greatly appreciated.

wickedchew

Quote:

Originally Posted by NISMOJim

I am working in Excel 2003, and am new to programming in Excel.
Column A is an imported date (mm/dd/yyyy), Column B is the same date (=A1 formatted as mmm) so that any year will work the same, and column C is text. In column D I want a statement something like this:
=IF(B1="Apr" AND C1="Joe",1,0).
Of course, this isn't working, even though it looks to me like it should. What am I missing? Any help with how to get this working as expected would be greatly appreciated.

=IF(AND(B1="Apr",C1="Joe"),1,0)

Mazzaropi

Quote:

Originally Posted by NISMOJim

I am working in Excel 2003, and am new to programming in Excel.
Column A is an imported date (mm/dd/yyyy), Column B is the same date (=A1 formatted as mmm) so that any year will work the same, and column C is text. In column D I want a statement something like this:
=IF(B1="Apr" AND C1="Joe",1,0).
Of course, this isn't working, even though it looks to me like it should. What am I missing? Any help with how to get this working as expected would be greatly appreciated.

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

Dear NISMOjim, Good Morning

You don´t need to use another colunm to control month´s date.

Try this one: IF(AND(MONTH(A1)=4,C1="JOE"),1,0)

Use the month´s number.(1=Jan;2=Feb;3=Mar...)

NISMOJim

Quote:

Originally Posted by Mazzaropi

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

Dear NISMOjim, Good Morning

You don´t need to use another colunm to control month´s date.

Try this one: IF(AND(MONTH(A1)=4,C1="JOE"),1,0)

Use the month´s number.(1=Jan;2=Feb;3=Mar...)

Works perfect. Thanks so much for the help, and I'm sure I will be back with more questions.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IF Statement Help - Not seeing whole cell	stumped	Excel Worksheet Functions	4	December 31st 09 05:06 PM
IF Statement for On One Cell Comparing to the Other Cell	Daren	Excel Worksheet Functions	5	October 29th 08 12:20 PM
if statement? Want to populate whats in cell or N/A if cell is zer	Melanie	Excel Worksheet Functions	3	December 27th 07 05:49 PM
How to use if statement for a #N/A cell	noyau	Excel Discussion (Misc queries)	3	January 11th 07 02:43 PM
If statement on cell with #N/A	ChrisMattock	Excel Worksheet Functions	4	June 28th 06 11:14 AM

Menu

About Us