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

"Valerie" wrote:

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?

Try this:

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

--
Biff
Microsoft Excel MVP


"Valerie" wrote in message
...
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?

Thanks so much!

"T. Valko" wrote:

Try this:

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

--
Biff
Microsoft Excel MVP


"Valerie" wrote in message
...
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?

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

"Gary Orr" wrote:

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

"Valerie" wrote:

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?

You're welcome!

--
Biff
Microsoft Excel MVP


"Valerie" wrote in message
...
Thanks so much!

"T. Valko" wrote:

Try this:

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

--
Biff
Microsoft Excel MVP


"Valerie" wrote in message
...
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?