Logic If formula - multi-parameters can not get to work??

[Tech Express]

techexpressinc (Programmer) Apr 10, 2009
I can not get the if formula to work for checking multiple cells.

I have it working with one cell but I need it to working check two cells.

I am checking for the value less than 5 in multiple cells and if it is put a
one in the output cell for a counter.

It works for one cell checking.
=IF(AC2<6,1,0) This works.

Below this does not work:
I need to check multiple cells thou I tried below and it fails??
=IF(((AC2<6) or (AD2<6)),1,0)

Any good ideas on how to adjust it?
Thanks Russ at Scaninc.org

--

 

[Fred Smith]

Any good ideas on how to adjust it?
Yes, read up on the OR function.

Try this:
=IF(or(AC2<6,AD2<6),1,0)

Regards,
Fred

 

[Gary''s Student]

You need to use OR as a function:

=IF(OR((AC2<6), (AD2<6)),1,0)

 

[Tech Express]

It Work! Thanks.
--
Russ at scaninc.org

Yes, read up on the OR function.

Try this:
=IF(or(AC2<6,AD2<6),1,0)

Regards,
Fred