Search, if then formula issue

[saprklingunicorn]

Hi!
Any help is appreciated!
trying to use the following so if cell in A column contains "pint" it will assign a volume of 0.545L to the cell in D Column.
=IF(ISNUMBER(SEARCH("Pint",A115)),"0.545")

So far not having any luck.

Would like to then expand it so I can apply to all of column A, so "midi =0.285", 16 Pack= 6" etc.
If anyone has any insight please? I can't find any tips on office help to match the data set.
Michelle

 

[saprklingunicorn]

Oh dear! Realised i'm working in row 117 but searching A115! It works.