Dear Han, please send example sheet.
On Thu, Jun 3, 2010 at 1:16 PM, Han <microsoftexcelc...@gmail.com> wrote: > 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 > -- One Team One Dream One Goal Warm Regards, Vikas Chauhan E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, "We can't Spell S_ccess without U" Life is Very beautiful !!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. -- ---------------------------------------------------------------------------------- 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
