STEVENS3010
Board Regular
- Joined
- Feb 4, 2020
- Messages
- 89
- Office Version
- 365
- 2016
- Platform
- Windows
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
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
Excel Formula:
=AND($C$6>=50,$C$6<=88,OR($F$2="Red",$F$2="Blue"))