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

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

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

I did try this... =IF(TODAY()-B1230,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 with
"false." Does anyone have any advice? Any help would be greatly
appreciated.

Andrew


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

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

This formula is missing the false_value for the outer IF
=IF(TODAY()-B1230,IF(ISBLANK(I12),"OVERDUE",""))
so add one in
=IF(TODAY()-B1230,IF(ISBLANK(I12),"OVERDUE",""), "")
but why not
=IF(AND(TODAY()-B1230,ISBLANK(I12)),"OVERDUE","")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"getmhawks" wrote
in message ...

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

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

I did try this... =IF(TODAY()-B1230,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 with
"false." Does anyone have any advice? Any help would be greatly
appreciated.

Andrew


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

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

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" wrote
in message ...

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

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

I did try this... =IF(TODAY()-B1230,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 with
"false." Does anyone have any advice? Any help would be greatly
appreciated.

Andrew


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

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

Thanks guys. That works great! However, I realized that if C12 is blank
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 out
yet. So what could I add into the function that would cause a blank
cell if another cell was empty.


So if Today()-b1230 and I12 is blank then it is "overdue". Unless C12
is blank, then the cell should come up empty(false). If neither of the
first two requiements are met then it should come up empty(false) as
well.

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


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

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

Try this (not tested):

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

getmhawks wrote:
Thanks guys. That works great! However, I realized that if C12 is blank
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 out
yet. So what could I add into the function that would cause a blank
cell if another cell was empty.


So if Today()-b1230 and I12 is blank then it is "overdue". Unless C12
is blank, then the cell should come up empty(false). If neither of the
first two requiements are met then it should come up empty(false) as
well.

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


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