[Solved] Limiting Liquidity Reserves

Discuss the spreadsheet application
Post Reply
Frank1000
Posts: 12
Joined: Sun Apr 16, 2017 9:38 pm

[Solved] Limiting Liquidity Reserves

Post by Frank1000 »

Hi,
im trying to get solved how i can limit the liquidity reserves and payouts, so the max. total (accumulated value) is not exceeded.

What is the right function for this ?
Image_2017-05-13__15-35-13__1494682514.png
I have re-built this here in G-Sheet for easy access & edit.

Regards,
Frank
Last edited by Hagar Delest on Wed May 17, 2017 4:58 pm, edited 1 time in total.
Reason: tagged [Solved].
OpenOffice 4 on Windows 10
User avatar
keme
Volunteer
Posts: 3704
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Limiting Liquidity Reserves

Post by keme »

For the example cell G8 (If I am reading you right), try:

Code: Select all

=MIN(G$1*$B8;$D8-F6)
Apache OO 4.1.12 and LibreOffice 7.5, mostly on Ms Windows 10
Frank1000
Posts: 12
Joined: Sun Apr 16, 2017 9:38 pm

Re: Limiting Liquidity Reserves

Post by Frank1000 »

Great :) Thx Keme
OpenOffice 4 on Windows 10
Post Reply