Operating baseline before disrtibutions

T

txgold

I'm trying to make a formula to enter into a forecasted expense
workbook that will add "monthly net(q47)" to "ending monthly cash(q49)
if the "ending monthly cash(q49)" is less than $30000, and if greate
than $30000 make a distribution. I currently have investor
distribution line set up as follows
=IF(Q47>0,Q47*0.84,0)

In other words if q47-monthly net is greater than $0, then 84% get
distributed to investor A. If q47-monthly net is $0 or less, the
nothing gets distributed to investor A.

Currently ending monthly cash is set up as follows
=Q25+Q47-Q53-Q71
Q25 is beginning monthly cash, q47 is monthly net, q53 is investor
distribution, and q71 is investor B distribution.

I want to add a condition that will account for keeping a minimu
monthly reserve, and if this minimum reserve is met, then the curren
distribution takes effect, otherwise monthly net gets added to endin
monthly cash.

There is no way anyone will understand this, but just in case some ha
the same type of dyslexia that I have, I wanted to ask for ya'lls help
 
T

txgold

txgold;440476 said:
I'm trying to make a formula to enter into a forecasted expense
workbook that will add "monthly net(q47)" to "ending monthly cash(q49)
if the "ending monthly cash(q49)" is less than $30000, and if greate
than $30000 make a distribution. I currently have investor
distribution line set up as follows
=IF(Q47>0,Q47*0.84,0)

In other words if q47-monthly net is greater than $0, then 84% get
distributed to investor A. If q47-monthly net is $0 or less, the
nothing gets distributed to investor A.

Currently ending monthly cash is set up as follows
=Q25+Q47-Q53-Q71
Q25 is beginning monthly cash, q47 is monthly net, q53 is investor
distribution, and q71 is investor B distribution.

I want to add a condition that will account for keeping a minimu
monthly reserve, and if this minimum reserve is met, then the curren
distribution takes effect, otherwise monthly net gets added to endin
monthly cash.

There is no way anyone will understand this, but just in case some ha
the same type of dyslexia that I have, I wanted to ask for ya'lls help.
Click to expand...

Any ideas
 
N

NBVC

Do you mean something like this?:

=Min(5000,Q25+Q47-Q53-Q71)

this will always show a minimum of 5000 unless the result o
Q25+Q47-Q53-Q71 is greater than 5000

--
NBV

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com
 
Top