IF Statments in Excel

  • Thread starter Thread starter Valerie
  • Start date Start date
V

Valerie

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?
 
Nest your if statement in another if statement that checks to see if a cell
is blank:

=IF(ISBLANK(M7),"NA",IF(M7<=J7,"ON TIME","LATE"))

you could even go as far as:

=IF(or(ISBLANK(M7), ISBLANK(J7)),"NA",IF(M7<=J7,"ON TIME","LATE"))
 
That is exactly what I was looking for. I couldn't remember the "ISBLANK"
term. Thanks for the help!
 
Back
Top