Hi

I created a column which has a drop down with the option of choosing the word blister or loose.

What I would like to do is set the value of the cell to 1 if either word is chosen or the value would be zero if cell was left blank.

Any help would be greatly appreciated