It looks like there are a few issues with the formula you've provided. Here's a breakdown of what's going wrong:
- The syntax for the AND function is incorrect. You need to separate each condition with a comma, not a space. So it should be
Code:
AND(CI7<=30,D7=70%)
. - The syntax for the OR function is also incorrect. You need to provide two separate conditions for it to evaluate. So it should be
Code:
OR(AND(CI7=90,D7<=50%),[second condition])
. - You haven't provided a value for the TRUE condition of the IF statement. This is necessary for the formula to work.
Here's a revised formula that should work for you:
Code:
=IF(AND(CI7<=30,D7=70%),"Green",IF(AND(CI7=90,D7<=50%),"Green",""))
This formula first checks if both conditions are met (CI7 is less than or equal to 30 and D7 is greater than or equal to 70%). If they are, it returns "Green". If not, it moves on to the next IF statement, which checks if the second set of conditions are met (CI7 is greater than or equal to 90 and D7 is less than or equal to 50%). If they are, it returns "Green". If neither set of conditions is met, it returns an empty string (""), which means no formatting will be applied.