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",""), "")
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",""), "")
to be SURE, you may want this. Touching the space bar can ruin your life
=IF(OR(E5="",E5=" "),"",yourformula)
--
Don Guillett
SalesAid Software
[email protected]
"getmhawks" <[email protected]> wrote
in message news:[email protected]...
>
> 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",""), "")
>
>
> --
> getmhawks
> ------------------------------------------------------------------------
> getmhawks's Profile:
> http://www.excelforum.com/member.php...o&userid=35242
> View this thread: http://www.excelforum.com/showthread...hreadid=551213
>
>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
getmhawks" <[email protected]> wrote in
message news:[email protected]...
>
> 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",""), "")
>
>
> --
> getmhawks
> ------------------------------------------------------------------------
> getmhawks's Profile:
> http://www.excelforum.com/member.php...o&userid=35242
> View this thread: http://www.excelforum.com/showthread...hreadid=551213
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks