formula help
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 |
formula help
=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 |
All times are GMT +1. The time now is 08:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com