IF Statments in Excel

[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?

 

[Gary Orr]

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"))

 

[T. Valko]

Try this:

=IF(AND(M7<>"",M7<=J7),.............

 

[Valerie]

Thanks so much!

Try this:

=IF(AND(M7<>"",M7<=J7),.............

 

[Valerie]

That is exactly what I was looking for. I couldn't remember the "ISBLANK"
term. Thanks for the help!

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thanks so much!