Hi
Please can someone help me with a formula.
I have these columns
A ug/L JAR 1 | A ug/L JAR 2 | A ug/L JAR 3 | B g/L JAR 1 | B g/L JAR 2 | B g/L JAR 3 | A Final ug/L |
43 | 25 | 100 | 1.36 | 0.01 | 12.00 | ? |
I need a formula if possible to calculate a "A Final ug/L" result based on certain conditions.
Conditions is:
1. If a particular B group JAR is below 0.3 g/L or above 3.0 g/L then the corresponding A group JAR sample should be rejected in calculations for final value.
2. If one of the three corresponding A group JAR sample is rejected then the remaining two A group JAR samples are calculated as mean value (average) in the final value.
3. If two of the corresponding A group JAR sample is rejected then the remaining one A group JAR samples is just the final value.
4. If no JARs rejected then all three A group JAR samples calculated as median (middle value) value.
5. Zero values and blanks not included in calculation.
I really appreciate any help given.
Thanks