Thread: Nested Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Betty K Betty K is offline
external usenet poster
 
Posts: 8
Default Nested Formula

If the calculated amount in W is greater than 0 and the date in U is later
than 2/19/09, then 15 needs to be added to W. I tried the following formula,
but even if the date is after 2/20/09, it still adds the 15.

=SUM(AND(W20,U2="2/20/09"),(W2+15))

What am I doing wrong? Thanks for your help!