Does anyone know how to word an If Statement if you have a column that is
filled with text and you want the column next to automatically recogize it as
insert the number 1?

For example, Column A ask for assets. If an asset is listed, I want Column
B to automatically populated with the number 1.

Thanks