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

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

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

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

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