Buidling level equation

Amigo · Post by **Amigo** » Wed Aug 02, 2006 9:53 pm

I have a problem to build an equation in my model to calculate that:
I have stock or quantity B fixed every year
i have A= different monthly amount to be withdrawn from B each month
So i need to calculate C the residual each month C=B-A (the equation should read the initial value of B every 12 months and start the calculation)
Regards
Amgad

Post by **Administrator** » Thu Aug 03, 2006 4:41 pm

How about using SAMPLE IF TRUE. Use that on your 'B' at the start of every 12 months, and use that in the equations.

Tony.

kayarman · Post by **kayarman** » Sun Aug 06, 2006 11:55 am

i don't know how about this problem.

[Edited on 8-6-2006 by kayarman]