Help adjusting an 'AND' Formula

[STEVENS3010]

Hey all,

Is anybody please able to help me adjust the below formula to achieve the result I'm looking for please?

In summary, I'm trying to return a true/false value in a particular cell that is dependent on the value in two other cells.

For example, in cell 'N4' I would like a 'true' value to return if the number in cell 'C6' is between 50 and 88, and the value in 'F2' is either 'Red' or 'Blue'.

However, where it gets complicated is that I have a second criteria where I would also like a 'true' value to return in the same cell, based on the number in cell 'C6' being between 21-49 and the value in cell F2 being 'green'.

Is it possible to adapt the current formula to achieve this?

Current formula

=AND($C$6>=50,$C$6<=88,OR($F$2="Red",$F$2="Blue"))

 

[offthelip]

try this:

=OR(AND($C$6<88,$C$6>50,OR($F$2="Red",$F$2="Blue")),AND($C$6<49,$C$6>21,$F$2="green"))

 

[etaf]

based on the number in cell 'C6' being between 21-49 and the value in cell F2 being 'green'.

As
=AND($C$6>=50,$C$6<=88,OR($F$2="Red",$F$2="Blue"))
Works, then you just need to add an OR for the new combination

= AND ( $C$6>=21,$C$6<=49, $F$2="Green")
= AND($C$6>=50,$C$6<=88,OR($F$2="Red",$F$2="Blue"))

then an
OR ( AND ( $C$6>=21,$C$6<=49, $F$2="Green"), AND($C$6>=50,$C$6<=88,OR($F$2="Red",$F$2="Blue")) )

 

[STEVENS3010]

Thanks both, I've just ran the formula suggested by both of you but unfortunately only the original part of the formula appears to work, the additional part I'm looking to add still returns a false value when cells 'C6' and 'F2' meet the criteria. (i.e. cell C6 has a number between 21-49 and F2 is 'green'. Any ideas?

 

[STEVENS3010]

Apologies, this was my mistake. I had incorrectly changed a cell reference. The above works - thank you both.

 

[etaf]

you are welcome