Conditional If Statements
Hello--I am a novice with respect to conditional if statements. I
would like to express the following in a formula:
If cell A =5 AND cell B2, return Red
If cell A<=5 AND cell B=0, return Green
If cell A=5 AND cell B=0 OR Cell A<=5 AND cell B=2-5, Return Yellow.
I know this is a lot. What I would like to know is whether it is even
possible to include this many conditions.
Thanks!
|