Thread: I want to create an IF statement that leaves a cell blank if....
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default I want to create an IF statement that leaves a cell blank if....
=IF(ISBLANK(A2),"","A2 is non_blank")

Regards,
Stefi

€žKK€ ezt Ă*rta:

I want to create an IF statement that leaves a cell blank if the value in
another cell is blank or zero. How would I craft this formula please?


Reply With QuoteReply With Quote