If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|