Need help with iteration or recursion

Hi! I don't know if that is right thread,but I need help with that problem! I know that could be solved by VBA functions,but I need only solved by formulas only and(or) LAMBDA function.

These could be done in spreadsheet calculations:

All things start from P1,P2,P3(A9:C9 cells) values - sum in A2(that is B),then are calculated - OV,RTP,K(B2:D2 cells).The resulting K(D2 cell) helps to be determined NO1,NO2,NO3(A14:C14 cells) by O1,O2,O3(A11:C11 cells).

These NO1,NO2,NO3 determined NP1,NP2,NP3 (A16:C16 cells) which determined NP1,NP2,NP3(A16:C16 cells).Then new K1(D5 cell) is determined.

These values K1,NO1,NO2,NO3(D5,A14:C14 cells) determined B2(which is not in the spreadsheet).Then process repeated till B<=100,01%.

I'm sorry for my bad english and poor explanations,but I appreciate anyone could help to solve that problem.

in the sample B2 is SUM(A14:C14)

what determines the values in a14:c14 they appear fixed

An easy solution if they can be changed is C14=1-a14-b14

Or another line

in a15 =A14/(SUM($A14:$C14)) copy to the right

B2= sum(a15:c15)

Thanks for the answer,but I may be couldn't explain what I wish to do,cause of my poor English.

B2 is SUM(A24:C24) and not SUM(A14:C14).

Yes A14:C14 are fixed - they are the origin values of P1:P3.

And then A2,B2,C2,D2 are calculated.First value of B(A2 cell is calculated) and it's = 101.72% in this case.

Further by iteration is calculated the 2nd value of B,it's B1(A5 cell) and it's = 100.21%

And etc.

The iterations should be stopped when B value is <=100.01%

And I've just wish to have only these output data - that last B value and last values of P1,P2,P3(which are changed every iteration in - 14 row - 1st fixed values,19 row - changed in 1st iteration,24 row - changed in 2nd iteration and etc.)

Hi,again! I couldn't solve the problem by SOLVER,but I've solved it partially by LAMBDA function.And is there a way or function in excel that execute output values in more cells - I mean that function is in one cell and output values are in any other cells?