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

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

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

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

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

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