This is my spreadsheet:
C D H I J
Month Start Date End Date June July
5,821.83 1/1/08 5,821.83

I have a formula that looks at a start date and places the monthly salary
based on the start date in the appropriate month, and carries it forward for
the rest of the year. How do I incorporate an additional statement that also
looks at the "End Date" field, and will enter a zero in the last pay month,
and subsequent months for the rest of the year? My formula is:

=IF($C5="",0,IF($G5=--"6/30/2008",0,IF($G5<--"6/1/2008",$C5,IF(AND($G5<--"6/30/2008",$G5--"6/14/2008"),$C5/2,))))

Why the hard-coded dates? it is very difficult to determine what your data
looks like from that example.

--
__________________________________
HTH

Bob

"Micki" wrote in message
...
This is my spreadsheet:
C D H I J
Month Start Date End Date June July
5,821.83 1/1/08 5,821.83

I have a formula that looks at a start date and places the monthly salary
based on the start date in the appropriate month, and carries it forward
for
the rest of the year. How do I incorporate an additional statement that
also
looks at the "End Date" field, and will enter a zero in the last pay
month,
and subsequent months for the rest of the year? My formula is:

=IF($C5="",0,IF($G5=--"6/30/2008",0,IF($G5<--"6/1/2008",$C5,IF(AND($G5<--"6/30/2008",$G5--"6/14/2008"),$C5/2,))))

That's the only way I knew how to do it. It'd rather reference other cells.
Here's what I want. I someone has a start date of June 1, then enter a full
month's salry. If they have a start date of June 15, enter 1/2 mo. salary. If
however, sonone started January 1 and quit September 30, I want the monthly
salary to reflect $0 Oct - Dec.

"Bob Phillips" wrote:

Why the hard-coded dates? it is very difficult to determine what your data
looks like from that example.

--
__________________________________
HTH

Bob

"Micki" wrote in message
...
This is my spreadsheet:
C D H I J
Month Start Date End Date June July
5,821.83 1/1/08 5,821.83

I have a formula that looks at a start date and places the monthly salary
based on the start date in the appropriate month, and carries it forward
for
the rest of the year. How do I incorporate an additional statement that
also
looks at the "End Date" field, and will enter a zero in the last pay
month,
and subsequent months for the rest of the year? My formula is:

=IF($C5="",0,IF($G5=--"6/30/2008",0,IF($G5<--"6/1/2008",$C5,IF(AND($G5<--"6/30/2008",$G5--"6/14/2008"),$C5/2,))))