I need help with a formula...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to do a formula for a conditionning formatting....How do I say
=IF cell a2 OR b2<2 AND c2 OR d2=1, then apply the formatting?
I have =IF(OR(A2<2,B2<2),(OR(C2=1,D2=1)))
But's it's reading all 4 situations and applying the formatting if any 4 of
the criteria is met.
 
You should try =IF(AND((OR(A2<2,B2<2),(OR(C2=1,D2=1)))). didn't check it out
so I may be wrong but it should be similar to this.
 
That's because you forgot the AND
=IF(AND(OR(A2<2,B2<2),OR(C2=1,D2=1)))

HTH

Die_Another_Day
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying formulas across columns 2
More Planned and Actual Cycle Times 5
countifs Function not giving desired result with date criteria 2
formula shows false 6
Excluding Repeating Numbers Help!1 5
Logical if more than 7 4
trying to set conditions for a range of cells 8
How do I calculate a weighted average and exclude the empthy cells 2

Back
Top