View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KalliKay KalliKay is offline
external usenet poster
 
Posts: 18
Default 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