Spreadsheet: 824365d1680526816-if-cell-blank-return-the-value-to-on-or-another-cell-template-gc-glenn-kennedy-ok-copy
Sheet: DONNEES & CALCULS MPs

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (SUMPRODUCT(--(MOD(COLUMN(AD8:INDEX(AD8:[NAME]:LM8<0);-(ISFORMULA(AD8:LM8));AD8:INDEX(AD8:LM8;COLUMN()-1)))*-1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | touslesE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3 |  |  | Essai 1 |  |  | Essai 2 |  |  | Essai 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE
 |  |  |  | problem |  | Essai 1 |  | Essai 2 |  | Essai 3 |  |  |  |  |  | [NAME] |  |  | POIVRE NOIR HE |  |  | [NAME] |  |  | [NAME]
 |  |  | RAW MATERIALS | IF F8 blank return the value of G8 or H8 and if not return the value of F8 | [NAME] | TOTAL (-) E12 | TOTAL (+) E1 | TOTAL (-) E2 | TOTAL (+) E2 | TOTAL (-) E3 | TOTAL (+) E3 | QTE TYPE | QTE ESSAI 1 | QTE ESSAI 2 | CAS | MP % | APPORTE | + / - | MP %2 | APPORTE2 | + / -2 | MP %3 | APPORTE3 | + / -3 | MP %4 | APPORTE4 | + / -4 | MP %5 | APPORTE5 | + / -5 | MP %6 | APPORTE6 | + / -6 | MP %7 | APPORTE8 | + / -9 | MP %210 | APPORTE211 | + / -212 | MP %313 | APPORTE314 | + / -315 | MP %416 | APPORTE417 | + / -418 | MP %519 | APPORTE520 | + / -521 | MP %622 | APPORTE623 | + / -624 | MP %72 | APPORTE83 | + / -94 | MP %2105 | APPORTE2116 | + / -2127 | MP %3138 | APPORTE3149 | + / -31510 | MP %41611 | APPORTE41712 | + / -41813 | MP %51914 | APPORTE52015 | + / -52116 | MP %62217 | APPORTE62318 | + / -62419 | MP %73 | APPORTE84 | + / -95 | MP %2106 | APPORTE2117 | + / -2128 | MP %3139 | APPORTE31410 | + / -31511 | MP %41612 | APPORTE41713 | + / -41814 | MP %51915 | APPORTE52016 | + / -52117 | MP %62218 | APPORTE62319 | + / -62420 | MP %74 | APPORTE85 | + / -96 | MP %2107 | APPORTE2118 | + / -2129 | MP %31310 | APPORTE31411 | + / -31512 | MP %41613 | [NAME] | + / -41815 | MP %51916 | APPORTE52017 | + / -52118 | MP %62219 | APPORTE62320 | + / -62421 | MP %75 | APPORTE86 | + / -97 | MP %2108 | [NAME] | + / -21210 | MP %31311 | APPORTE31412 | + / -31513 | MP %41614 | APPORTE41715 | + / -41816 | MP %51917 | APPORTE52018 | + / -52119 | MP %62220 | APPORTE62321 | + / -62422 | MP %76 | APPORTE87 | + / -98 | MP %2109 | APPORTE21110 | + / -21211 | MP %31312 | APPORTE31413 | + / -31514 | MP %41615 | APPORTE41716 | + / -41817 | MP %51918 | APPORTE52019 | + / -52120 | MP %62221 | APPORTE62322 | + / -62423 | MP %77 | APPORTE88 | + / -99 | MP %21010 | APPORTE21111 | + / -21212 | MP %31313 | APPORTE31414 | + / -31515 | MP %41616 | APPORTE41717 | + / -41818 | MP %51919 | APPORTE52020 | + / -52121 | MP %62222 | APPORTE62323 | + / -62424 | MP %78 | APPORTE89 | + / -910 | MP %21011 | APPORTE21112 | + / -21213 | MP %31314 | APPORTE31415 | + / -31516 | MP %41617 | [NAME] | + / -41819 | MP %51920 | APPORTE52021 | + / -52122 | MP %62223 | [NAME] | + / -62425 | MP %79 | APPORTE810 | + / -911 | MP %21012 | APPORTE21113 | + / -21214 | MP %31315 | APPORTE31416 | + / -31517 | MP %41618 | APPORTE41719 | + / -41820 | MP %51921 | APPORTE52022 | + / -52123 | MP %62224 | APPORTE62325 | + / -62426 | MP %710 | APPORTE811 | + / -912 | MP %21013 | APPORTE21114 | + / -21215 | MP %31316 | APPORTE31417 | + / -31518 | MP %41619 | APPORTE41720 | + / -41821 | MP %51922 | APPORTE52023 | + / -52124 | MP %62225 | APPORTE62326 | + / -62427 | MP %711 | APPORTE812 | + / -913 | MP %21014 | APPORTE21115 | + / -21216 | MP %31317 | APPORTE31418 | + / -31519 | MP %41620 | APPORTE41721 | + / -41822 | MP %51923 | APPORTE52024 | + / -52125 | MP %62226 | APPORTE62327 | + / -62428 | MP %712 | APPORTE813 | + / -914 | MP %21015 | APPORTE21116 | + / -21217 | MP %31318 | APPORTE31419 | + / -31520 | MP %41621 | APPORTE41722 | + / -41823 | MP %51924 | APPORTE52025 | + / -52126 | MP %62227 | APPORTE62328 | + / -62429 | MP %713 | APPORTE814 | + / -915 | MP %21016 | APPORTE21117 | + / -21218 | MP %31319 | APPORTE31420 | + / -31521 | MP %41622 | APPORTE41723 | + / -41824 | MP %51925 | APPORTE52026 | + / -52127 | MP %62228 | APPORTE62329 | + / -62430 | MP %714 | APPORTE815 | + / -916 | MP %21017 | APPORTE21118 | + / -21219 | MP %31320 | APPORTE31421 | + / -31522 | MP %41623 | APPORTE41724 | + / -41825 | MP %51926 | APPORTE52027 | + / -52128 | MP %62229 | APPORTE62330 | + / -62431 | MP %715 | APPORTE816 | + / -917 | MP %21018 | APPORTE21119 | + / -21220 | MP %31321 | APPORTE31422 | + / -31523 | MP %41624 | APPORTE41725 | + / -41826 | MP %51927 | APPORTE52028 | + / -52129 | MP %62230 | APPORTE62331 | + / -62432 | MP %716 | APPORTE817 | + / -918 | MP %21019 | APPORTE21120 | + / -21221 | MP %31322 | APPORTE31423 | + / -31524
 |  |  | ACETATE ALPHA TERPENYLE (MPs) |  |  |  |  |  |  |  |  |  |  |  |  | -100 |  | 8 | 5 |  | -4 | 0.13 |  |  | 0.13 |  | -4 | 0.13 |  |  | 0.13
 |  |  | ACETATE BORNYLE (MPs)
 |  |  | ACETATE CITRONELLYLE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  | ACETATE GAMMA TERPENYLE (MPs) |  |  |  |  |  |  |  |  |  |  |  |  | 0.02 |  | -1 | 0.02 |  |  | 0.02 |  |  | 0.02 |  |  | 0.02 |  |  | 0.02
 |  |  | ACETATE GERANYLE 98 |  |  |  |  |  |  |  |  |  |  |  |  | 0.32 |  |  | 0.32 |  |  | 0.32 |  |  | 0.32 |  |  | 0.32 |  |  | 0.32
 |  |  | ACETATE LINALYLE | 5 | 0 |  | 5 |  |  |  |  |  |  |  |  | 30.8 |  |  | 20 |  |  | 50 |  |  | 30.8 |  |  | 30.8 |  |  | 30.8
 |  |  | ACETATE NERYLE | 6 | 6 | 4 | 2 |  |  |  |  |  |  |  |  | 0.33 |  |  | 0.33 |  |  | 0.33 |  |  | 0.33 |  |  | 0.33 |  |  | 0.33
 |  |  | ACETATE OCTYLE | -2 | 0 | -2 |  |  |  |  |  |  |  |  |  | 0.2 |  |  | 0.2 |  |  | 0.2 |  |  | 0.2 |  |  | 0.2 |  |  | 0.2
 |  |  | ALDEHYDE C10 EXTRA (DECANAL) |  |  |  |  |  |  |  |  |  |  |  |  | 0.05 |  |  | 0.05 |  |  | 0.05 |  |  | 0.05 |  |  | 0.05 |  |  | 0.05
 |  |  | [NAME] (NONANAL) |  |  |  |  |  |  |  |  |  |  |  |  | 0.01 |  |  | 0.01 |  |  | 0.01 |  |  | 0.01 |  |  | 0.01 |  |  | 0.01
 |  |  | ALLOAROMADENDRENE (MPs)
 |  |  | ALPHA TERPINENE |  |  |  |  |  |  |  |  |  |  |  |  | 0.12 |  |  | 0.12 |  |  | 0.12 |  |  | 0.12 |  |  | 0.12 |  |  | 0.12
 |  |  |  | exemples