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

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

Try this:

=IF(A1<"",1,"")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Kehau37" <u38500@uwe wrote in message news:7a21fc430fd8e@uwe...
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

Thank you so much!! This works!

RagDyer wrote:
Try this:

=IF(A1<"",1,"")

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
[quoted text clipped - 6 lines]

Thanks

You're welcome, and thank you for the feed-back.

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Kehau37" <u38500@uwe wrote in message news:7a22b25ffc7ee@uwe...
Thank you so much!! This works!

RagDyer wrote:
Try this:

=IF(A1<"",1,"")

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
[quoted text clipped - 6 lines]

Thanks