Hi guys,
Hope you can help with this -
I need a formula for column I 'ActiveIngredientG'
If the cell in column G 'Antibiotic' contains the value 'Florocol' I would like the corresponding cell in column I to equal the value in column H 'QuantityProductG' divided by 2.
If, however, the value...