Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |