If Formula with dates
 

I have a table and I am trying to use a if formulas to return a value. For
example,
Return a value if the date on that row is less or equal to January 31, 2008.
--
Phil

If Formula with dates
 

Phil,

Is the value you are returning going to be a constant or another cell within
that row, or on another worksheet, etc.

"Phil" wrote:

I have a table and I am trying to use a if formulas to return a value. For
example,
Return a value if the date on that row is less or equal to January 31, 2008.
--
Phil

If Formula with dates
 

Yes!

Basically the folowing is how I want it to work:

I have a sample of the table that I working on as showing below:
Name Date Amount January February ....
Un Nyobe January-08 $56.00
Kwame Krumah June-08 12.00

I would like excel to return amount entered in the "amount column" in a
specific month if the date is within that month. For example, in the month of
January, please entered $56 if the date is anywhere between January 1 thru
31, 2008
--
Phil



--
Phil


"Thomas [PBD]" wrote:

Phil,

Is the value you are returning going to be a constant or another cell within
that row, or on another worksheet, etc.

"Phil" wrote:

I have a table and I am trying to use a if formulas to return a value. For
example,
Return a value if the date on that row is less or equal to January 31, 2008.
--
Phil

If Formula with dates
 

Another Cell
--
Phil


"Thomas [PBD]" wrote:

Phil,

Is the value you are returning going to be a constant or another cell within
that row, or on another worksheet, etc.

"Phil" wrote:

I have a table and I am trying to use a if formulas to return a value. For
example,
Return a value if the date on that row is less or equal to January 31, 2008.
--
Phil

If Formula with dates
 

Phil,

Assuming that Name starts in A1, Date is formatted as a "Date", and your
month columns are Text:

=IF(TEXT($B2,"mmmm")=D$1,$C2,"")

Place this formula into the January column to the right of Amount. Copy and
Paste Special (Formula) into the columns of the months, you should have your
answer. If needed you can replace the "" with 0 to pull a zero value for
that row where the Months do not match.

"Phil" wrote:

Yes!

Basically the folowing is how I want it to work:

I have a sample of the table that I working on as showing below:
Name Date Amount January February ....
Un Nyobe January-08 $56.00
Kwame Krumah June-08 12.00

I would like excel to return amount entered in the "amount column" in a
specific month if the date is within that month. For example, in the month of
January, please entered $56 if the date is anywhere between January 1 thru
31, 2008
--
Phil



--
Phil


"Thomas [PBD]" wrote:

Phil,

Is the value you are returning going to be a constant or another cell within
that row, or on another worksheet, etc.

"Phil" wrote:

I have a table and I am trying to use a if formulas to return a value. For
example,
Return a value if the date on that row is less or equal to January 31, 2008.
--
Phil