View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Workbook Workbook is offline
external usenet poster
 
Posts: 121
Default Making a Cell Go Blank

I want to modify this formula =IF(Sheet1!N2=241,1,""), so that if N2 is
blank the cell containing this formula will become blank. I have tried
variations of =IF(N2<""(Sheet1!N2<=241,1,""), based on earlier suggestions
but to no avail. Do you have any thoughts?