EvilBankster
New Member
- Joined
- Jun 6, 2011
- Messages
- 6
So, I tried seeking help in my very first thread, but something tells me the title bored potential helpers. Here's the original thread:
http://www.mrexcel.com/forum/showthread.php?t=555178
And here's a summary of the problem:
I'm using an excel spreadsheet to help structure interest rate derivatives. I have run into an impenetrable problem. If you don't want to read the first thread, picture this:
Column A: represents the PPMT for a particular loan. These numbers will all be different and could be $0 if there is are X periods of interest only.
Column B: needs to be the average of every 12 corresponding cells in Column A (B1 maps to A1, etc), but if there are X periods of interest only, then the result needs to be $0 and average needs to begin at AX and map to BX, etc.
Right now, I'm using a MOD function to try and get the cells to average every 12 cells after all non-zero numbers but I can't make it work.
All help is appreciated. Images of the spreadsheet would probably help, but I can't figure out how to load/attach them.
http://www.mrexcel.com/forum/showthread.php?t=555178
And here's a summary of the problem:
I'm using an excel spreadsheet to help structure interest rate derivatives. I have run into an impenetrable problem. If you don't want to read the first thread, picture this:
Column A: represents the PPMT for a particular loan. These numbers will all be different and could be $0 if there is are X periods of interest only.
Column B: needs to be the average of every 12 corresponding cells in Column A (B1 maps to A1, etc), but if there are X periods of interest only, then the result needs to be $0 and average needs to begin at AX and map to BX, etc.
Right now, I'm using a MOD function to try and get the cells to average every 12 cells after all non-zero numbers but I can't make it work.
All help is appreciated. Images of the spreadsheet would probably help, but I can't figure out how to load/attach them.
