ExcelBanter - Excel Formula if cell is empty then no if text in cell then yes

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel Formula if cell is empty then no if text in cell then yes (https://www.excelbanter.com/excel-worksheet-functions/123290-excel-formula-if-cell-empty-then-no-if-text-cell-then-yes.html)

Kathy

Excel Formula if cell is empty then no if text in cell then yes

I have a summary sheet and I need the cell on this sheet to say no if a cell
on a different sheet is blank or yes if there is data in the cell. Anyone
have any ideas?

John Bundy

Excel Formula if cell is empty then no if text in cell then yes

Example for data on sheet 2 in cell A1
=IF(Sheet2!A1="","No","Yes")
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Kathy" wrote:

I have a summary sheet and I need the cell on this sheet to say no if a cell
on a different sheet is blank or yes if there is data in the cell. Anyone
have any ideas?

Gary''s Student

Excel Formula if cell is empty then no if text in cell then yes

On Sheet2

=IF(Sheet1!J25="","no","yes")
--
Gary''s Student

"Kathy" wrote:

I have a summary sheet and I need the cell on this sheet to say no if a cell
on a different sheet is blank or yes if there is data in the cell. Anyone
have any ideas?

All times are GMT +1. The time now is 04:07 AM.