Good morning everyone & Merry Christmas.
Wondering if some one could help me with this as i'm clueless (I DIDNT set up the data layout) it's taken from the web.
However, I need a formula that can return the correct Meursing code dependant upon on 4 variables ( Starch / Glucose), Sucrose/Inverted Sugar/IsoGlucose/ Milk Fat, Milk Proteins.
How it works (dependant upon your variables) is that it looks in the top row for Starch Glucose content, then Sucrose etc, Milk Fat in the first column and then Milk proteins in the second column (Warning: this might look very messy as I post it)
So for example, Starch Glucose of "≥ 5 < 25", Sucrose of "≥ 5 <30", Milk Fat of "≥ 0 < 1,5", Milk Protein of "≥ 2,5 < 6", would be Code "7026". Not sure if anyone can help me with this as the data layout seems like a mess.
EDIT: I've had to use an image, as the pasted data didn't pull through properly and I can't get XL2BB to work properly on my work computer.
The data is also here: Meursing - Fintaric
Wondering if some one could help me with this as i'm clueless (I DIDNT set up the data layout) it's taken from the web.
However, I need a formula that can return the correct Meursing code dependant upon on 4 variables ( Starch / Glucose), Sucrose/Inverted Sugar/IsoGlucose/ Milk Fat, Milk Proteins.
How it works (dependant upon your variables) is that it looks in the top row for Starch Glucose content, then Sucrose etc, Milk Fat in the first column and then Milk proteins in the second column (Warning: this might look very messy as I post it)
So for example, Starch Glucose of "≥ 5 < 25", Sucrose of "≥ 5 <30", Milk Fat of "≥ 0 < 1,5", Milk Protein of "≥ 2,5 < 6", would be Code "7026". Not sure if anyone can help me with this as the data layout seems like a mess.
EDIT: I've had to use an image, as the pasted data didn't pull through properly and I can't get XL2BB to work properly on my work computer.
The data is also here: Meursing - Fintaric
