IF Statments in Excel
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?
|