Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to create a formula with expiry condition
hi all,
Need assistance here. I need a formula to calculate the total amount expired by month if the fund allocate did not utilize within 6 months. e.g. Total balance amount of 330 in Apr 07 did not utilize in the 7th month (Oct 07). Total balance amount of 240 in Aug 07 did not utlize upon reaching Feb 08. I need the formula to calculate on this. Please advise. Thanks Month Total Amount Used Total Expired Amount Jan-07 240 0 Feb-07 240 0 Mar-07 240 250 Apr-07 360 0 May-07 0 0 Jun-07 0 500 Jul-07 0 0 Aug-07 240 0 Sep-07 0 0 Oct-07 0 0 330 Nov-07 0 0 Dec-07 0 0 Jan-08 0 0 Feb-08 0 0 240 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to create a formula with expiry condition
Mountain:
I don't know of a formula to use but you could use a matrix where is picks up the available amount and carries them forward. I used this for expiring tax losses but it it gets complicated. -- Hope this helps Martin Fishlock, www.nyfconsultants.com, Bangkok, Thailand Please do not forget to rate this reply. "mountain" wrote: hi all, Need assistance here. I need a formula to calculate the total amount expired by month if the fund allocate did not utilize within 6 months. e.g. Total balance amount of 330 in Apr 07 did not utilize in the 7th month (Oct 07). Total balance amount of 240 in Aug 07 did not utlize upon reaching Feb 08. I need the formula to calculate on this. Please advise. Thanks Month Total Amount Used Total Expired Amount Jan-07 240 0 Feb-07 240 0 Mar-07 240 250 Apr-07 360 0 May-07 0 0 Jun-07 0 500 Jul-07 0 0 Aug-07 240 0 Sep-07 0 0 Oct-07 0 0 330 Nov-07 0 0 Dec-07 0 0 Jan-08 0 0 Feb-08 0 0 240 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to create a formula with expiry condition
Hi Martin,
Thanks for your reply. Would you able to advise me / give me an example for matrix? Thanks. "Martin Fishlock" wrote: Mountain: I don't know of a formula to use but you could use a matrix where is picks up the available amount and carries them forward. I used this for expiring tax losses but it it gets complicated. -- Hope this helps Martin Fishlock, www.nyfconsultants.com, Bangkok, Thailand Please do not forget to rate this reply. "mountain" wrote: hi all, Need assistance here. I need a formula to calculate the total amount expired by month if the fund allocate did not utilize within 6 months. e.g. Total balance amount of 330 in Apr 07 did not utilize in the 7th month (Oct 07). Total balance amount of 240 in Aug 07 did not utlize upon reaching Feb 08. I need the formula to calculate on this. Please advise. Thanks Month Total Amount Used Total Expired Amount Jan-07 240 0 Feb-07 240 0 Mar-07 240 250 Apr-07 360 0 May-07 0 0 Jun-07 0 500 Jul-07 0 0 Aug-07 240 0 Sep-07 0 0 Oct-07 0 0 330 Nov-07 0 0 Dec-07 0 0 Jan-08 0 0 Feb-08 0 0 240 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA For Expiry date | Excel Discussion (Misc queries) | |||
Expiry date | Excel Worksheet Functions | |||
create a pop-up alert when a condition is reached in excel | Excel Discussion (Misc queries) | |||
Create a condition and allows a automatic comment | Excel Worksheet Functions | |||
how to create a condition returning 2 different drop down lists? | Excel Worksheet Functions |