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!
|