Adding A Not(IsBlank) To IF Statement(help)
 

I want to add something to this formula that makes the statement false
if there is nothing in cell C12. How would I add a not(isblank(C12))
statement to this or is there a better way. Thanks!

=IF(TODAY()-B1230,IF(ISBLANK(I12),"OVERDUE",""), "")


--
getmhawks
------------------------------------------------------------------------
getmhawks's Profile: http://www.excelforum.com/member.php...o&userid=35242
View this thread: http://www.excelforum.com/showthread...hreadid=551213

Adding A Not(IsBlank) To IF Statement(help)
 

to be SURE, you may want this. Touching the space bar can ruin your life
=IF(OR(E5="",E5=" "),"",yourformula)

--
Don Guillett
SalesAid Software

"getmhawks" wrote
in message ...

I want to add something to this formula that makes the statement false
if there is nothing in cell C12. How would I add a not(isblank(C12))
statement to this or is there a better way. Thanks!

=IF(TODAY()-B1230,IF(ISBLANK(I12),"OVERDUE",""), "")


--
getmhawks
------------------------------------------------------------------------
getmhawks's Profile:
http://www.excelforum.com/member.php...o&userid=35242
View this thread: http://www.excelforum.com/showthread...hreadid=551213

Adding A Not(IsBlank) To IF Statement(help)
 

add something to this formula that makes the statement false
if there is nothing in cell C12

For which branch?

=IF(TODAY()-B1230,IF(ISBLANK(I12),"OVERDUE",""), "")

Could be better expressed as:

=IF(AND(TODAY()-B1230,ISBLANK(I12)),"OVERDUE","")

Biff

getmhawks" wrote in
message ...

I want to add something to this formula that makes the statement false
if there is nothing in cell C12. How would I add a not(isblank(C12))
statement to this or is there a better way. Thanks!

=IF(TODAY()-B1230,IF(ISBLANK(I12),"OVERDUE",""), "")


--
getmhawks
------------------------------------------------------------------------
getmhawks's Profile:
http://www.excelforum.com/member.php...o&userid=35242
View this thread: http://www.excelforum.com/showthread...hreadid=551213