Spreadsheet: 824433d1680595450-if-cell-blank-return-the-value-to-on-or-another-cell-template-gc-copie-etaf
Sheet: DONNEES & CALCULS MPs

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (SUMPRODUCT(--(MOD(COLUMN(AD8:INDEX(AD8:[NAME]:LM8<0);-(ISFORMULA(AD8:LM8));AD8:INDEX(AD8:LM8;COLUMN()-1)))*-1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | touslesE
 | MIN(IF(E13:E15<>0;E13:E15)) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 2 |  |  | 3 |  |  | 4
 | SI(W8="";Z8;AA8) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
 | Si(et(Z8<0;AA>0);W8; |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE
 |  |  |  |  |  |  |  |  | Essai 1 |  | Essai 2 |  | Essai 3 |  |  |  |  |  | [NAME] |  | 8 | [NAME] |  | 82 | [NAME] |  | 100 | BERGAMOTE INCOLORE HE |  | 30 | BERGAMOTE INCOLORE HE |  | 89 | BERGAMOTE INCOLORE HE |  | 10 | BERGAMOTE TERPENES |  |  | BERGAMOTE TERPENES |  |  | BERGAMOTE TERPENES |  |  | BERGAMOTE SUBSTITUT |  |  | BERGAMOTE SUBSTITUT |  |  | BERGAMOTE SUBSTITUT |  |  | BERGAMOTE SUBSTITUT SANS CMR |  |  | BERGAMOTE SUBSTITUT SANS CMR |  |  | BERGAMOTE SUBSTITUT SANS CMR |  |  | MANDARINE JAUNE HE |  |  | MANDARINE JAUNE HE |  |  | MANDARINE JAUNE HE |  |  | MANDARINE VERTE HE |  |  | MANDARINE VERTE HE |  |  | MANDARINE VERTE HE
 | RAW MATERIALS | TOTAL APPORT | Colonne5 | Colonne6 | Colonne1 | Colonne52 | Colonne63 | Colonne14 | AJOUT | ENLEVER | AJOUT. | ENLEVER. | AJOUT.. | ENLEVER.. | 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
 | ACETATE ALPHA TERPENYLE (MPs) |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | 23 |  | 2 | 23 |  |  | 23 |  |  | 23 |  |  | 23 |  |  | 23 |  |  | 23 |  |  | 23 |  |  | 23
 | ACETATE BENZYLE |  | -43.4 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  | 2 |  | 1 | 2 |  |  | 2 |  |  | 2 |  |  | 2 |  |  | 2 |  |  | 2 |  |  | 2 |  |  | 2
 | ACETATE BETA TERPENYLE (MPs)
 | ACETATE BORNYLE (MPs) |  | -3.62 |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
 | ACETATE BULNESYL + EUGENOL (MPs) |  | 16.5 |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 45 |  | 4 | 45 |  |  | 45 |  |  | 45 |  |  | 45 |  |  | 45 |  |  | 45 |  |  | 45 |  |  | 45
 | ACETATE CARVYL CIS (MPs) |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  |  |  | 100 |  | 5 | 100 |  |  | 100 |  |  | 100 |  |  | 100 |  |  | 100 |  |  | 100 |  |  | 100 |  |  | 100
 | ACETATE CINNAMYLE |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  | 56 |  | 46 | 56 |  |  | 56 |  |  | 56 |  |  | 56 |  |  | 56 |  |  | 56 |  |  | 56 |  |  | 56
 | ACETATE CITRONELLYLE |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | 6 |  |  | 6 |  |  | 6 |  |  | 6 |  |  | 6 |  |  | 6 |  |  | 6 |  |  | 6 |  |  | 6
 | ACETATE DIHYDROCARVYL TRANS (MPs)
 | ACETATE EUGENYL (MPs)
 |  |  | There are 3 examples in the attached file.
 |  |  | G9= - 43.4 so I want him to make appear only this value in D9
 |  |  | [NAME] and G12 are blanks, so it should be either a negative value
 |  |  | D11=-3.62 (cause J11=-3.62)
 |  |  | neither positive
 |  |  | [NAME] (cause K12=16.5)
 |  |  | Thanks for you time !