There are several possibilities here, depending on exactly what you are
working with. How would you know that an entry in col A refers to an asset,
and not something else? If eg the words in col A will always start with the
word "asset", then you can use =IF(LEFT(A1,5)="Asset",1,0)
Without better info, it would be difficult to assist you, though

--
Hth

Kassie Kasselman
Change xxx to hotmail


"Kehau37" wrote:

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