ExcelBanter - If Function for Text

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If Function for Text (https://www.excelbanter.com/excel-discussion-misc-queries/118221-if-function-text.html)

Erin

If Function for Text

Is it possible to create a formula that would copy text from cell A1 to cell
C1 if cell B1 is blank and if cell B1 has text in it to copy it to cell C1?
If so, could someone tell me how?

Thanks,

Erin

David Biddulph

If Function for Text

=IF(B1="",A1,B1)
--
David Biddulph

"Erin" wrote in message
...
Is it possible to create a formula that would copy text from cell A1 to
cell
C1 if cell B1 is blank and if cell B1 has text in it to copy it to cell
C1?
If so, could someone tell me how?

Thanks,

Erin

All times are GMT +1. The time now is 06:53 AM.