IF and OR formulas

[jupops]

Good Aftertnoon

Cany anybody help me?What I am trying to do is if two arguments are correct then set an option to true. The problem I have 10 of these arguments that need be checked so for example

Col A Col B TRUE
1 0 TRUE
5 2 FALSE
45 4 TRUE
35 3 TRUE
12 1 TRUE

This represents: If Col A is between 0 and 10 and Col B is 0 then the statement is true. It also needs to check the statements: If Col A is between 11 and 20 and Col B is 1 then the statement is true or If Col A is between 31 and 40 and Col B is 3 then the statement is true. And so on.

The formula I tried does not seem ro to work :
=IF((A2>=0)*(A2<=10)*AND(B2=0),(TRUE) OR iF((A2>=1)*(A2<=20)*AND(B2=0),(TRUE) and so on,

Can anybody help?

Cheers

Jupops

 

[GlennUK]

Try this formula in C2 and copy it down ...

=B2=INT(MAX((A2-1),0)/10)

Cheers, Glenn.

 

[jupops]

Hi glen

I made a slight mistake (sorry) I ment the formula (that wont work) I have weitten as

=IF((A2>=0)*(A2<=10)*AND(B2=0),(TRUE) OR iF((A2>=11)*(A2<=20)*AND(B2=1),(TRUE) OR iF((A2>=21)*(A2<=30)*AND(B2=2),(TRUE) ......... and so on. Will this make a difference as I etill cant get it to work

Regards

Jupops

 

[GlennUK]

Hi,

just use my formula instead. The results will be exactly what you requested.

Cheers, Glenn.