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 ?
I have re-built this here in G-Sheet for easy access & edit.
Regards,
Frank
[Solved] Limiting Liquidity Reserves
[Solved] Limiting Liquidity Reserves
Last edited by Hagar Delest on Wed May 17, 2017 4:58 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
OpenOffice 4 on Windows 10
Re: Limiting Liquidity Reserves
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