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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using AND OR
Try this:
=IF(AND(B110,F11=L11,F11<0),(O11+Q11+S11+U11+W11 +Y11+AA11),0) Hope this helps. Pete Sunnyskies wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using AND OR
Thanks Pete.
Now I am getting greedy. Want to add to the conditions. If cells F11 and L11 equal greater than zero/nil but there is no data in O11+Q11+S11+U11+W11+Y11+AA11 or their sum equals zero/nil, I want a message in the formula cell to say "Hey missing some info here" Thanks "Pete_UK" wrote: Try this: =IF(AND(B110,F11=L11,F11<0),(O11+Q11+S11+U11+W11 +Y11+AA11),0) Hope this helps. Pete Sunnyskies wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using AND OR
Maybe this:
=IF(AND(F11=0,L11=0,O11+Q11+S11+U11+W11+Y11+AA11 =0),"Hey missing some info here",IF(AND(B110,F11=L11,F11<0),(O11+Q11+S11+U1 1+W11+Y11+AA11),0)) "Sunnyskies" wrote in message ... Thanks Pete. Now I am getting greedy. Want to add to the conditions. If cells F11 and L11 equal greater than zero/nil but there is no data in O11+Q11+S11+U11+W11+Y11+AA11 or their sum equals zero/nil, I want a message in the formula cell to say "Hey missing some info here" Thanks "Pete_UK" wrote: Try this: =IF(AND(B110,F11=L11,F11<0),(O11+Q11+S11+U11+W11 +Y11+AA11),0) Hope this helps. Pete Sunnyskies wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using AND OR
Great, works like a winner.
"PCLIVE" wrote: Maybe this: =IF(AND(F11=0,L11=0,O11+Q11+S11+U11+W11+Y11+AA11 =0),"Hey missing some info here",IF(AND(B110,F11=L11,F11<0),(O11+Q11+S11+U1 1+W11+Y11+AA11),0)) "Sunnyskies" wrote in message ... Thanks Pete. Now I am getting greedy. Want to add to the conditions. If cells F11 and L11 equal greater than zero/nil but there is no data in O11+Q11+S11+U11+W11+Y11+AA11 or their sum equals zero/nil, I want a message in the formula cell to say "Hey missing some info here" Thanks "Pete_UK" wrote: Try this: =IF(AND(B110,F11=L11,F11<0),(O11+Q11+S11+U11+W11 +Y11+AA11),0) Hope this helps. Pete Sunnyskies wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|