If Statement for Text
 

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

If Statement for Text
 

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

If Statement for Text
 

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

If Statement for Text
 

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

If Statement for Text
 

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