should it be if() or another logical function?
 

I want to get a 1 if true, a 0 if false...
What I'm looking at is:
if the total of 3 cells=0 AND the average of 5 other cells =30, then 1,
else 0
....typing this it seems like an and or an or function without the tue/false
return...what do you think?

Thanks!
--
Gina

should it be if() or another logical function?
 

=IF(AND(AVERAGE(A1:A5)=30,SUM(B1:B3)=0),1,0)

Dave
--
Brevity is the soul of wit.


"Gina" wrote:

I want to get a 1 if true, a 0 if false...
What I'm looking at is:
if the total of 3 cells=0 AND the average of 5 other cells =30, then 1,
else 0
...typing this it seems like an and or an or function without the tue/false
return...what do you think?

Thanks!
--
Gina

should it be if() or another logical function?
 

Try this:
=--AND(SUM(A1:A3)=0,AVERAGE(B1:B5)=30)


"Gina" wrote:

I want to get a 1 if true, a 0 if false...
What I'm looking at is:
if the total of 3 cells=0 AND the average of 5 other cells =30, then 1,
else 0
...typing this it seems like an and or an or function without the tue/false
return...what do you think?

Thanks!
--
Gina