Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
run a macro in a locked cell | Excel Discussion (Misc queries) | |||
How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
calculate anniversary of date after specified date | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions |