View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Valerie Valerie is offline
external usenet poster
 
Posts: 79
Default IF Statments in Excel

I am trying to do an if statement and my data column has some fields that are
blank. The statment looks like this, =IF(M7<=J7,"ON TIME","LATE TO NEED TO
NEED"). My problem is when M7 is blank, I get a false true statment. How do
I get the value to return a false statement, instead?