=if(F2<"",0,D2)

in E2, then drag fill down.

You would have to be clearer about "or in some cases only for the year of
2005 expenses. ". There is no function that can determine what those cases
are without a much clearer explanation.

--
Regards,
Tom Ogilvy


"EXCEL USER" wrote:

Please help me with the formula to calculate the column below titled "Amount
Int to be Chgd". If column titled Complition Date shows the date in any of
its cell than "amount Int to be Chge" should be zero but If there is no date
and the cell is blank than "Amount Int to be Chge" should represent the value
of a cell from the column titled "Total Expense" or in some cases only for
the year of 2005 expenses. Please help me to write this formula. Please
response me at . Thanks,

2004 2005 total Amount
Complition Interest
Expens Expense Expense Int to be Chgd Date
7%

Group 1 2,000 5,000 7,000 0
01/01/06

Group 1A 5,000 3,000 8,000 8,000