Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wild Card for IF statement?
I think this is simple but I can't figure it out. I am trying to
make a logic string such that I will get "TBD", "In Progress" or "Complete" text in a cell depending on the content of 2 other cells. I have 3 columns: Training Start Date; Training Completed Date and Training Status. If there are no dates entered in either date column- I want the status cell to say "TBD" if a date has been entered in the Start Date column the status column should say "In Process" and "Completed" in the status column if there is a date in the Date Completed column. I am not trying to verify the dates or anything fancy - just change the text in the status cell. I can do it with an IF statement if I could figure out the wild card for "any character" in a cell. The wild card for NO characters in a cell is "" - I thought the any character wild card should be "*" but that does not work. If I use =IF(A1="*", "In Progress", "TBD") and there is nothing in A1 I get "TBD", if I put a date in A1 I still get "TBD". If I use =IF(A1="","In process", "TBD" - nothing in A1 gives me "In Process" and any character in A1 gives me "TBD"/ Suggestions? Thanks for any help you can give me. Frusterated John |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wild Card for IF statement?
see if this will work if you put it in c1 and then put dates in a1 and b1.
=IF(AND(A11,B1=0),"In Progress",IF(AND(A10,B10),"Complete","TBD")) -- Gary Keramidas Excel 2003 "John" wrote in message ... I think this is simple but I can't figure it out. I am trying to make a logic string such that I will get "TBD", "In Progress" or "Complete" text in a cell depending on the content of 2 other cells. I have 3 columns: Training Start Date; Training Completed Date and Training Status. If there are no dates entered in either date column- I want the status cell to say "TBD" if a date has been entered in the Start Date column the status column should say "In Process" and "Completed" in the status column if there is a date in the Date Completed column. I am not trying to verify the dates or anything fancy - just change the text in the status cell. I can do it with an IF statement if I could figure out the wild card for "any character" in a cell. The wild card for NO characters in a cell is "" - I thought the any character wild card should be "*" but that does not work. If I use =IF(A1="*", "In Progress", "TBD") and there is nothing in A1 I get "TBD", if I put a date in A1 I still get "TBD". If I use =IF(A1="","In process", "TBD" - nothing in A1 gives me "In Process" and any character in A1 gives me "TBD"/ Suggestions? Thanks for any help you can give me. Frusterated John |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wild Card for IF statement?
I can do it with an IF statement if I could figure out the
wild card for "any character" in a cell. No wild card needed. Since you know that "" stands for no characters, then simply test if there are no characters and use that as your deciding logic... =IF(A1<"","There's something in the cell","Cell is empty") -- Rick (MVP - Excel) "John" wrote in message ... I think this is simple but I can't figure it out. I am trying to make a logic string such that I will get "TBD", "In Progress" or "Complete" text in a cell depending on the content of 2 other cells. I have 3 columns: Training Start Date; Training Completed Date and Training Status. If there are no dates entered in either date column- I want the status cell to say "TBD" if a date has been entered in the Start Date column the status column should say "In Process" and "Completed" in the status column if there is a date in the Date Completed column. I am not trying to verify the dates or anything fancy - just change the text in the status cell. I can do it with an IF statement if I could figure out the wild card for "any character" in a cell. The wild card for NO characters in a cell is "" - I thought the any character wild card should be "*" but that does not work. If I use =IF(A1="*", "In Progress", "TBD") and there is nothing in A1 I get "TBD", if I put a date in A1 I still get "TBD". If I use =IF(A1="","In process", "TBD" - nothing in A1 gives me "In Process" and any character in A1 gives me "TBD"/ Suggestions? Thanks for any help you can give me. Frusterated John |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wild Card for IF statement?
Hi John
Assuming your headers are in first row, in Training Status, C2 try the below formula =IF(AND(A2<"",B2<""),"Completed",IF(A2<"","In Progress","TBD")) -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "John" wrote: I think this is simple but I can't figure it out. I am trying to make a logic string such that I will get "TBD", "In Progress" or "Complete" text in a cell depending on the content of 2 other cells. I have 3 columns: Training Start Date; Training Completed Date and Training Status. If there are no dates entered in either date column- I want the status cell to say "TBD" if a date has been entered in the Start Date column the status column should say "In Process" and "Completed" in the status column if there is a date in the Date Completed column. I am not trying to verify the dates or anything fancy - just change the text in the status cell. I can do it with an IF statement if I could figure out the wild card for "any character" in a cell. The wild card for NO characters in a cell is "" - I thought the any character wild card should be "*" but that does not work. If I use =IF(A1="*", "In Progress", "TBD") and there is nothing in A1 I get "TBD", if I put a date in A1 I still get "TBD". If I use =IF(A1="","In process", "TBD" - nothing in A1 gives me "In Process" and any character in A1 gives me "TBD"/ Suggestions? Thanks for any help you can give me. Frusterated John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wild Card Vlookups | Excel Discussion (Misc queries) | |||
wild card in sumproduct | Excel Worksheet Functions | |||
Wild Card Search | Excel Worksheet Functions | |||
wild card -- help with formula | Excel Discussion (Misc queries) | |||
Wild card * | Excel Worksheet Functions |