and/or statement?

  • Thread starter Thread starter todd
  • Start date Start date
T

todd

I need to get a true or false if all my conditions are
met. Do I combine the and/or funtions to do that?

Here is what I have got.
=IF(OR(AND(J28=0,K28=0,L28=0,M28=0)),"",IF(COUNT(J28:K28)
=2,K28*J28,"")+IF(COUNT(L28:M28)=2,M28*L28))

I am working on a formula that the range may or may not
contain formulas,numbers or return "". I want to have the
formula return "" if ALL the cells in the range =0 or "".
(if it returns 0 then it messes with a formula on a
another worksheet).


TIA
Todd
 
I wasn't sure based on your post, but it looks like this is what you are
looking for:

=IF(OR(AND(J28=0,K28=0,L28=0,M28=0),COUNT(J28:M28=0)),"",IF(COUNT(J28:K28)=2
,K28*J28,"")+IF(COUNT(L28:M28)=2,M28*L28))

HTH
 
...
...
=IF(OR(AND(J28=0,K28=0,L28=0,M28=0),COUNT(J28:M28=0)),"",IF(COUNT(J28:K28)=2
,K28*J28,"")+IF(COUNT(L28:M28)=2,M28*L28))
Click to expand...
...

Is the 'COUNT(J28:M28=0)' term a typo for 'COUNT(J28:M28)=0'?

=IF(SUMPRODUCT((J28:M28<>0)*(J28:M28<>"")),your_formula_here,"")
 
Harlan Grove said:
...
..

J28:M28 == {-1,-2,-3,6} ?
Click to expand...

Ok, better not to make assumptions, left implicit.

=IF(OR(COUNTIF(J28:M28,0)=4,COUNTBLANK(J28:M28)=4),"",SUM(IF(COUNT(J28:K28)
=2,K28*J28,""),IF(COUNT(L28:M28)=2,M28*L28)))
 
Seems weird since I copied it directly from the formula bar...it seems that
I would have generated an error.....
 
Back
Top