Thread: Excel Formula if cell is empty then no if text in cell then yes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Bundy John Bundy is offline
external usenet poster
  
Posts: 60
Default 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?
Reply With QuoteReply With Quote