Downline to Pass Up calculation specific criteria

[tiong999]

Hello,

I have prepared some calculation that need generate calculation from somewhere downline -Nth developed into 2 suffix, and Pass Up if any quota met.

Please give a look closer to get know the rules on workbook i set.

Really appreciated any contribution of u guys.

Regards,
Tiong

 

[tiong999]

Sorry, here i attach two sample to make better comparison than file above.

Regards,
Tiong

 

[bosco_yip]

Perhaps,

In H5, copied to Q5 and 2 columns copied down :

=IFERROR(IF(INDEX(MID(C$7:C$14,2,99)-MID(C$6:C$13,2,99),ROWS($1:1))=1,D5*E6+D5*E7+(D6<>"")*(D7<>"")*SUM(H6:H$13),""),"")

Regards
Bosco

 

[tiong999]

Perhaps,

In H5, copied to Q5 and 2 columns copied down :

=IFERROR(IF(INDEX(MID(C$7:C$14,2,99)-MID(C$6:C$13,2,99),ROWS($1:1))=1,D5*E6+D5*E7+(D6<>"")*(D7<>"")*SUM(H6:H$13),""),"")

Regards
Bosco

Hello Bosco,

Formula will work excellent only if Code listed in the way i propose, which i actually skim it shorter for better view of the code structure.

Herewith i attach new sheet B, which i copy the real structure, and formula give me undesired result.

Hope u could understand that code structure that make the formula calculated, instead of row structure.

For instance:
M
M1
M2
M11
M12
M111
M121
M122
M1111
M11111
M11112

M11 & M12 derivative from M1 & M
M121 & M122 derivative from M12 & M1 & M
M11111 & M11112 derivative from M1111 ; M111 ; M11 ; M1 & M

Hopefully i didn't miss explained it false.

Regards,
Tiong

 

[bosco_yip]

Remove the formulas, manually give your expected results in your new file and upload the file.

Regards
Bosco

 

[tiong999]

Remove the formulas, manually give your expected results in your new file and upload the file.

Regards
Bosco

Hello buddy,

Thanks for your review, i appreciated of any contribution.

Regards,
Tiong

 

[tiong999]

Regards,
Tiong

My bad, i think i provided example not correctly ruled out.

Herewith i re-attach better example.

I appreciated of any review from u guys.

Regards,
Tiong