Formula question

[hhamlinwright08]

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]

 

[steve the fish]

Try this:

=H2/((G2="Florocol")+1)

 

[hhamlinwright08]

Hi Steve, that did the trick. Thanks!