Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I create an If Statement that will replace text | Excel Worksheet Functions | |||
Remove the "False" from Statement | Excel Worksheet Functions | |||
How do I use an if statement with Find and Replace | Excel Worksheet Functions | |||
Search and replace | Excel Worksheet Functions | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions |