How To Allocating Rent Between Two Categories?

[Han]

Original Question:

[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
FC CAM
Mkt CAM
Base
% Rent

I'm just working on allocating the last two, so I'm assuming that
there is rent remaining to be allocated from column G after allocating
to Gas, Hydro, Promo, FC CAM and Mkt CAM.

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.

Feel free to make what ever changes to the spreadsheet as necessary to
make it work.]

My Question:
I have done something to the question above. but what i have done is
allocated first to base rent than to % rent on a yearly basis, not on
monthly basis as required. for example, The eighth month's Base Rent
and %Rent should be 91.08 and -219.04, not 662.08 and (790.04) as my
formular calculated.I would appreciated if you could help me?

Thanks!

 

[Han]

I would like to send you the spreadsheet to understand my question if
you leave your email address?

Thank you help in advance!

 

[Han]

Base Rent:

=IF(AND(N17<SUM(Q17:W17),SUM($O$16:O16)<AG17,SUM($P$1616)>0),$Y
$4,IF(AND(SUM($P$1616)<$Y$4,SUM($P$1616)>0),SUM($P
$1616),IF(SUM($O$16:O16)<AG17,MIN(AG17-SUM($O$16:O16),IF(SUM($P
$1616)<0,N17-SUM(Q17:W17)+SUM($P$1616),N17-SUM(Q17:W17))))))

% Rent:

=IF(O17+SUM(Q17:W17)>AG17,0,N17-O17-SUM(Q17:W17))

I would like to send you the spreadsheet to understand my question if
you leave your email address?

Thank you help in advance!

Original Question:

[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
FC CAM
Mkt CAM
Base
% Rent

I'm just working on allocating the last two, so I'm assuming that
there is rent remaining to be allocated from column G after allocating
to Gas, Hydro, Promo, FC CAM and Mkt CAM.

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.

Feel free to make what ever changes to the spreadsheet as necessary to
make it work.]

My Question:
I have done something to the question above. but what i have done is
allocated first to base rent than to % rent on a yearly basis, not on
monthly basis as required. for example, The eighth month's Base Rent
and %Rent should be  91.08 and -219.04, not  662.08 and (790.04) asmy
formular calculated.I would appreciated if you could help me?

Thanks!- Hide quoted text -

- Show quoted text -