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