hhamlinwright08
New Member
- Joined
- Oct 5, 2017
- Messages
- 20
- Office Version
- 365
- Platform
- Windows
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 in column G is anything other than 'Florocol', e.g. Aquatet, then I would like the value in column I to be exactly the same as in column H.
I have filled out the correct values manually in the image below to show what I want to achieve.
Thanks!
[/IMG]
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 in column G is anything other than 'Florocol', e.g. Aquatet, then I would like the value in column I to be exactly the same as in column H.
I have filled out the correct values manually in the image below to show what I want to achieve.
Thanks!

