Trying to replace "false" in IF statement...

[getmhawks]

In this formula I cannot figure out how to keep "false" from coming u
when the statement is false. If it is not "OVERDUE", then I want th
cell to show nothing at all.

Here is the formula... =IF(TODAY()-B12>30,IF(ISBLANK(I12),"OVERDUE"
""))

I did try this... =IF(TODAY()-B12>30,IF(ISBLANK(I12),"OVERDUE", "NA"))
and it still came up "FALSE".

Everything works as far as I know but I don't want the row filled wit
"false." Does anyone have any advice? Any help would be greatl
appreciated.

Andre

 

[Bernard Liengme]

This formula is missing the false_value for the outer IF
=IF(TODAY()-B12>30,IF(ISBLANK(I12),"OVERDUE",""))
so add one in
=IF(TODAY()-B12>30,IF(ISBLANK(I12),"OVERDUE",""), "")
but why not
=IF(AND(TODAY()-B12>30,ISBLANK(I12)),"OVERDUE","")
best wishes

 

[Arvi Laanemets]

Hi

You havent'd determined the case TODAY()-B12<=30 - all such cases return
FALSE for your formula

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


Arvi Laanemets

 

[getmhawks]

Thanks guys. That works great! However, I realized that if C12 is blan
then I don't want "overdue" to pop up. Basically there are "overdues
all the way down the part of the column that has not been filled ou
yet. So what could I add into the function that would cause a blan
cell if another cell was empty.


So if Today()-b12>30 and I12 is blank then it is "overdue". Unless C1
is blank, then the cell should come up empty(false). If neither of th
first two requiements are met then it should come up empty(false) a
well.

This is the formula I used from your help. How should I alter to it?
=IF(AND(SUM(TODAY()-B12)>30,I12<>""),"OVERDUE",""

 

[Mark Lincoln]

Try this (not tested):

=IF(AND(SUM(TODAY()-B12)>30,I12<>"",C2<>""),"OVERDUE","")