Page 1 of 1

Buidling level equation

Posted: Wed Aug 02, 2006 9:53 pm
by Amigo
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

Posted: Thu Aug 03, 2006 4:41 pm
by Administrator
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.

Posted: Sun Aug 06, 2006 11:55 am
by kayarman
i don't know how about this problem.




[Edited on 8-6-2006 by kayarman]