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

[getmhawks]

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()-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 with "false." Does anyone have any advice? Any help would be greatly appreciated.

Andrew

[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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"getmhawks" <[email protected]> wrote
in message news:[email protected]...
>
> 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()-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 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
>

[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" <[email protected]> wrote
in message news:[email protected]...
>
> 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()-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 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
>

[getmhawks]

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 an empty cell(false statement) if C12 was blank.


So if Today()-b12>30 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","")

EDIT: Basically column C has to have something in the cell before an "overdue" can be issued. I hope that makes sense.

[Mark Lincoln]

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()-b12>30 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