Spreadsheet: 885325d1734817027-if-cell-blank-return-the-value-to-on-or-another-cell-forms-without-sensitive
Sheet: DATA

 |  |  |  |  |  |  |  | A METTRE DANS L'ESSAI |  |  |  |  |  |  |  | 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
 |  |  | 3 | 4 | 5 |  |  |  |  |  |  |  |  |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE |  |  | CODE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | BERGAMOTE INCOLORE HE |  |  | BERGAMOTE INCOLORE HE |  |  | BERGAMOTE INCOLORE HE |  |  | BERGAMOTE TERPENES |  |  | BERGAMOTE TERPENES |  |  | BERGAMOTE TERPENES |  |  | BERGAMOTE SUBSTITUT |  |  | BERGAMOTE SUBSTITUT |  |  | BERGAMOTE SUBSTITUT |  |  | BERGAMOTE SUBSTITUT SANS CMR |  |  | BERGAMOTE SUBSTITUT SANS CMR |  |  | BERGAMOTE SUBSTITUT SANS CMR |  |  |  |  | 22 |  |  |  |  |  |  |  |  | 40
 | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column20 | Column21 | Column22 | Column23 | Column24 | Column25 | Column26 | Column27 | Column28 | Column29 | Column30 | Column31 | Column32 | Column33 | Column34 | Column35 | Column36 | Column37 | Column38 | [NAME] | Column40 | Column41 | Column42 | Column43 | Column44 | Column45 | Column46 | Column47 | Column48 | Column49 | Column50 | Column51 | Column52 | Column53 | Column54 | Column55 | Column56 | Column57 | Column58 | Column59 | Column60 | Column61 | Column62 | Column63 | Column64 | Column65 | Column66 | Column67 | Column68 | Column69 | Column70 | Column71 | Column72 | Column73 | Column74 | Column75 | Column76 | Column77 | Column78 | Column79 | Column80 | Column81 | Column82 | Column83 | Column84 | Column85 | Column86 | Column87 | Column88 | Column89 | Column90 | Column91 | Column92 | Column93 | Column94 | Column95 | Column96 | Column97 | Column98 | Column99 | Column100 | Column101 | Column102 | Column103 | Column104 | Column105 | Column106 | Column107 | Column108 | Column109 | Column110 | Column111 | Column112 | Column113 | Column114 | Column115 | Column116 | Column117 | Column118 | Column119 | Column120 | Column121 | Column122 | Column123 | Column124 | Column125 | Column126 | Column127 | Column128 | Column129 | Column130 | Column131 | Column132 | Column133 | Column134 | Column135
 | SAMPLE 1 |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  | 7.14 |  |  | 7.14 |  |  | 7.14 |  |  | 2.48 |  |  | 2.48 |  |  | 2.48 |  |  | 3.53 |  |  | 3.53 |  |  | 3.53 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17.05 |  |  | 17.05 |  |  | 17.05 |  |  | 30 |  |  | 16.79 |  |  | 16.79
 | SAMPLE 2 |  |  |  |  |  |  |  |  |  |  | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.14 |  |  | 0.14 |  |  | 0.14 |  |  | 0.45 |  |  | 0.45 |  |  | 0.45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02 |  |  | 0.02 |  |  | 0.02
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.03 |  |  | 0.03 |  |  | 0.03
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.04 |  |  | 0.04 |  |  | 0.04
 | EXPECTED RESULT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.8 |  |  | 9.8 |  |  | 9.8 |  |  | 10.01 |  |  | 10.01 |  |  | 10.01 |  |  | 2.76 |  |  | 2.76 |  |  | 2.76 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.11 |  |  | 0.11 |  |  | 0.11 |  |  | 0.16 |  |  | 0.16 |  |  | 0.16
 | SAMPLE 1 |  |  |  |  | -4.249 | 15.751 |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17.05 |  |  | 0.12 |  |  | 0.12 |  |  | 30 |  |  | 0.28 |  |  | 0.28
 | SAMPLE 2 |  |  |  |  | 0.011 | 0.211 |  |  |  |  | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.14 |  |  |  |  |  |  |  |  | 0.45 |  |  | 0.28 |  |  | 0.28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.91 |  |  | 0.91 |  |  | 0.91 |  |  | 2.94 |  |  | 2.94 |  |  | 2.94 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.24 |  |  | 0.24 |  |  | 0.24 |  |  | 0.3 |  |  | 0.3 |  |  | 0.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.67 |  |  | 0.67 |  |  | 0.67
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.07 |  |  | 0.07 |  |  | 0.07 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.69 |  |  | 0.69 |  |  | 0.69
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.58 |  |  | 3.58 |  |  | 3.58 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.9 |  |  | 0.9 |  |  | 0.9 |  |  | 0.95 |  |  | 0.95 |  |  | 0.95
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.21 |  |  | 7.21 |  |  | 7.21 |  |  | 6.3 |  |  | 6.3 |  |  | 6.3 |  |  | 18.27 |  |  | 18.27 |  |  | 18.27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.39 |  |  | 1.39 |  |  | 1.39 |  |  | 1.64 |  |  | 1.64 |  |  | 1.64
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.95 |  |  | 0.95 |  |  | 0.95 |  |  | 1.51 |  |  | 1.51 |  |  | 1.51 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.57 |  |  | 1.57 |  |  | 1.57 |  |  | 1.79 |  |  | 1.79 |  |  | 1.79
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.04 |  |  | 1.04 |  |  | 1.04 |  |  | 6.28 |  |  | 6.28 |  |  | 6.28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.3 |  |  | 2.3 |  |  | 2.3 |  |  | 2.14 |  |  | 2.14 |  |  | 2.14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40.62 |  |  | 40.62 |  |  | 40.62 |  |  | 35.86 |  |  | 35.86 |  |  | 35.86 |  |  | 60.24 |  |  | 60.24 |  |  | 60.24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 73.34 |  |  | 73.34 |  |  | 73.34 |  |  | 72.23 |  |  | 72.23 |  |  | 72.23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05 |  |  | 0.05 |  |  | 0.05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | the value of BL20 and BU20 dependent on the vaalue in BL18 and BU 18 IF BL20 and BU20 are < 0 the result in D20 is correct cause the formula calculate the difference between a positive and negative value  for example if [NAME] and BU18=2 then we have the sum of -9,400 and -6,249= -15,649 from which we do the substraction of 4,351 (3,751+0,600) = -11,30 in D20 which is ok  if ever the value in BL20 and/or BU20 and/or the other cells till the end is positve the formula doesn't consider the positive value but only the negative. So if  [NAME] and BU18=40 we have 3,751+12 = 15,751 and -6,249. So I need to make him understand that he has to consider the positive value as a additional quantity and then we'll have -4,249 in G20 (-6,249+2). so the result in D20 will be correct