Hi Everyone,
I need some help with this formula problem I'm working on, so if you have any free time you can help me solve it would be great. Tab #4 on the attached spreadsheet is the closest I have for the formula to work. Essentially colums A to H are used to calculate how much rent the tenants have to pay, with column G being the total amount they have to pay. This part I'm sure works correctly. The part I need help with is that the amount in column G has to be allocated to the following accounts in this order Gas, Hydro, Promo FCCAM MCAM Base % Rent Assuming that there is rent remaining to be allocated from column G after allocating to Gas, Hydro, Promo, FCCAM and MCAM. The remaining balance has to be allocated first to base rent than to % rent on a monthly basis. If some rent is allocated to % rent, and the next months sales are so low that the base rent is fully filled we need to first reduce % rent until it is 0 before reducing the base rent. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe