Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested IF Formula | Excel Discussion (Misc queries) | |||
Nested IF and AND formula | New Users to Excel | |||
Nested Formula - HELP | Excel Worksheet Functions | |||
nested formula | Excel Worksheet Functions | |||
Nested Formula | Excel Worksheet Functions |