Excel "IF()" Statement Help????
 

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

I am developing a spread sheet that needs to display the data /
contents of one cell in another cell only if the following conditions
are true / have been met.

Example:

Cell A1 contains a purchase date (i.e. 11-12-2003)

Cell B1 contains a purchase price (i.e. $40.00)

In addition to the above columns (purchase date & purchase price) I
have 12 columns labeled Jan 03 - Dec 03 for the months of the year.

I want to create an "IF()" statement that will disply the purchase
price in the correct month column and a "0" in the rest of the columns
based on the following conditions:

Condition A: IF(MONTH(A1=X))

and

Condition B: IF(YEAR(A1=Y))

I have tried the following functions, but they always display the
purchase price no matter what date has been entered.

1.) =IF(AND(MONTH(A1=X),YEAR(A1=Y)),B1,0)
2.) =IF(MONTH(A1=X),B1,IF(YEAR(A1=Y),B1,0))

Any assistance provided will be greatly appreciated, and thank you in
advance to all that may offer assistance.

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

Excel "IF()" Statement Help????
 

This is basicly a nested if statement, where :
A2 = purchase date,
B2 = purchase price,
D1 to O1 contained reference date (Jan-03 to Dec - 03)
----------------------------------------------------------------------------
----------------
Formula for D2 is : =IF(MONTH(A2)=MONTH(D1),IF(YEAR(A2)=YEAR(D1),B2,0) ,0)
----------------------------------------------------------------------------
-----------------
Then just fill across and down, minding cell adresses as you go

Good Luck,
Tumbleweed

"WebWizard97" wrote in message
m...
---------------------------------------------------------------

I am developing a spread sheet that needs to display the data /
contents of one cell in another cell only if the following conditions
are true / have been met.

Example:

Cell A1 contains a purchase date (i.e. 11-12-2003)

Cell B1 contains a purchase price (i.e. $40.00)

In addition to the above columns (purchase date & purchase price) I
have 12 columns labeled Jan 03 - Dec 03 for the months of the year.

I want to create an "IF()" statement that will disply the purchase
price in the correct month column and a "0" in the rest of the columns
based on the following conditions:

Condition A: IF(MONTH(A1=X))

and

Condition B: IF(YEAR(A1=Y))

I have tried the following functions, but they always display the
purchase price no matter what date has been entered.

1.) =IF(AND(MONTH(A1=X),YEAR(A1=Y)),B1,0)
2.) =IF(MONTH(A1=X),B1,IF(YEAR(A1=Y),B1,0))

Any assistance provided will be greatly appreciated, and thank you in
advance to all that may offer assistance.

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

Excel "IF()" Statement Help????
 

I just wanted to say thank you to Tumbleweed, Tom and Ken for your
assistance with my little IF() problem all of your suggestions and
tips work exactly like I wanted them too.

Thanks again for your help.


WebWizard97