Thread: Stopping IF command from entering zero or 1 for blank cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nick S Nick S is offline
external usenet poster
  
Posts: 2
Default Stopping IF command from entering zero or 1 for blank cells
Dear All, I have a panel of data with some blank cells (absent observations).
If I replace the blanks with anything ("""", #NA etc.) and then run the IF
command (say, IF(B2361,1,B236)), I get a one where the blank cells used to
be. I want the value to remain blank, instead of recording a false
'observation'. Can anyone help?

Nick
Reply With QuoteReply With Quote