If Statement for Text

  • Thread starter Thread starter Kehau37
  • Start date Start date
K

Kehau37

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
 
You're welcome, and thank you for the feed-back.

--

Regards,

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

Thank you so much!! This works!
Try this:

=IF(A1 said:
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
Click to expand...
[quoted text clipped - 6 lines]
Thanks
Click to expand...
Click to expand...
 
Back
Top