If(AND) Statement

[KalliKay]

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

 

[JP]

Try this:

=IF(AND(Q5=100%,W5=""),"Action Required",W5)


--JP

 

[Teethless mama]

=IF(AND(Q5=1,W5=""),"Action Required",W5)

 

[KalliKay]

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.

 

[KalliKay]

Simple fix....I got it. Thanks for your assistance.

KK

 

[JP]

Glad to hear it!

--JP

Simple fix....I got it.  Thanks for your assistance.

KK