Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using AND OR
Afternoon,
Sure just typed this, but anyway. Scenario to explain. I have a date in B11, with a value in F11 and another in L11 with more values in O11:AA11. So to explain my problem: 1. If there is a date in B11 AND OR 2. Cell F11 equals L11 but their values must not be zero Then add O11:AA11 If all three of these criterias are meet then add up O11:AA11 I have this: =IF(AND(B11="",F11=L11),0,(O11+Q11+S11+U11+W11+Y11 +AA11)) Thanks |