B
Betty K
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(W2>0,U2>="2/20/09"),(W2+15))
What am I doing wrong? Thanks for your help!
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(W2>0,U2>="2/20/09"),(W2+15))
What am I doing wrong? Thanks for your help!