Thread: If(AND) Statement
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default 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
Reply With QuoteReply With Quote