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

G

getmhawks

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()-B12>30,IF(ISBLANK(I12),"OVERDUE",""), "")
 
D

Don Guillett

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

Biff

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

For which branch?
=IF(TODAY()-B12>30,IF(ISBLANK(I12),"OVERDUE",""), "")

Could be better expressed as:

=IF(AND(TODAY()-B12>30,ISBLANK(I12)),"OVERDUE","")

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top