Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If(AND) Statement
Project Completion % in Cell Q5 might be 0%, 50%, or 100%
Actual Completion Date in Cell W5 might be empty or will have a date, 8/18/2008 I need to write a statement that says if Q5 = 100% and W5 is empty to enter "Action Required" otherwise to enter the date that is in W5. Can you help me with this please? Thanks. KK |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If(AND) Statement
Try this:
=IF(AND(Q5=100%,W5=""),"Action Required",W5) --JP On Sep 18, 11:03*am, KalliKay wrote: Project Completion % in Cell Q5 might be 0%, 50%, or 100% Actual Completion Date in Cell W5 might be empty or will have a date, 8/18/2008 I need to write a statement that says if Q5 = 100% and W5 is empty to enter "Action Required" otherwise to enter the date that is in W5. Can you help me with this please? *Thanks. KK |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If(AND) Statement
=IF(AND(Q5=1,W5=""),"Action Required",W5)
"KalliKay" wrote: Project Completion % in Cell Q5 might be 0%, 50%, or 100% Actual Completion Date in Cell W5 might be empty or will have a date, 8/18/2008 I need to write a statement that says if Q5 = 100% and W5 is empty to enter "Action Required" otherwise to enter the date that is in W5. Can you help me with this please? Thanks. KK |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If(AND) Statement
If there is no date in W5 and Q5 does not equal 100%, the value placed in the
date field comes up with 1/0/1900. How do I get this to place nothing in the field then? Thanks. "JP" wrote: Try this: =IF(AND(Q5=100%,W5=""),"Action Required",W5) --JP On Sep 18, 11:03 am, KalliKay wrote: Project Completion % in Cell Q5 might be 0%, 50%, or 100% Actual Completion Date in Cell W5 might be empty or will have a date, 8/18/2008 I need to write a statement that says if Q5 = 100% and W5 is empty to enter "Action Required" otherwise to enter the date that is in W5. Can you help me with this please? Thanks. KK |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If(AND) Statement
Simple fix....I got it. Thanks for your assistance.
KK "KalliKay" wrote: If there is no date in W5 and Q5 does not equal 100%, the value placed in the date field comes up with 1/0/1900. How do I get this to place nothing in the field then? Thanks. "JP" wrote: Try this: =IF(AND(Q5=100%,W5=""),"Action Required",W5) --JP On Sep 18, 11:03 am, KalliKay wrote: Project Completion % in Cell Q5 might be 0%, 50%, or 100% Actual Completion Date in Cell W5 might be empty or will have a date, 8/18/2008 I need to write a statement that says if Q5 = 100% and W5 is empty to enter "Action Required" otherwise to enter the date that is in W5. Can you help me with this please? Thanks. KK |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If(AND) Statement
Glad to hear it!
--JP On Sep 18, 11:35*am, KalliKay wrote: Simple fix....I got it. *Thanks for your assistance. KK "KalliKay" wrote: If there is no date in W5 and Q5 does not equal 100%, the value placed in the date field comes up with 1/0/1900. *How do I get this to place nothing in the field then? * Thanks. "JP" wrote: Try this: =IF(AND(Q5=100%,W5=""),"Action Required",W5) --JP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |