Cell to populate if other column has any text
Closed
therock90
-
Updated by therock90 on 16/03/17 at 10:14 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Mar 16, 2017 at 10:57 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Mar 16, 2017 at 10:57 AM
Related:
- Cell to populate if other column has any text
- If cell contains date then return value ✓ - Office Software Forum
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Excel: If Date =, then enter a value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Mar 16, 2017 at 10:57 AM
Mar 16, 2017 at 10:57 AM
therock90, Good morning.
Try to use:
=IF(ISTEXT(B1), "Y", "")
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use:
=IF(ISTEXT(B1), "Y", "")
Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
