= LET(
accumulated, SUMIFS(drawdown, year, "<="&year),
IF(accumulated<LoanAmount, accumulated, LoanAmount))
= SCAN(0,year,
LAMBDA(acc,yr,
MIN(acc+XLOOKUP(yr,year,drawdown), LoanAmount)
)
)
It also depends on the version of Excel that you are using. Assuming 365
should work but, in future, so wouldCode:= LET( accumulated, SUMIFS(drawdown, year, "<="&year), IF(accumulated<LoanAmount, accumulated, LoanAmount))
Code:= SCAN(0,year, LAMBDA(acc,yr, MIN(acc+XLOOKUP(yr,year,drawdown), LoanAmount) ) )
rajkenya1
Please, reread Forum Rules
... and You should remember soon few basic steps which are for You too.Site Rules - New Users - Please Read
Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...chandoo.org
Is that the equivalent of " I don't give a **** ***** cross posting rules?" ?Thank you so much for your reply and sharing your knowledge. Much appreciated.
Not surprising. I post the solutions I use and care little for 'standard' spreadsheet practice. A version that should work on legacy Excel isThank you so much
Although have never seen a formula like this.
Cheers for your help
= IF(
SUMIFS(drawdown, year, "<="&year) < LoanAmount,
SUMIFS(drawdown, year, "<="&year),
LoanAmount
)
Is that the equivalent of " I don't give a **** ***** cross posting rules?" ?
moderator: Maybe that OP do not understand that everywhere are rules.