There are two ways to enter formulas in Excel. In this example the formula in cell D2 says. If either of the arguments is found to be FALSE or both the arguments entered in the AND function is FALSE then the IF function will return a blank string.
If you are looking for a case-sensitive IF AND formula wrap one or more arguments of AND into the EXACT function as it is done in the linked example.
The IF function is the main logical function in Excel and is therefore the one to understand first. IFORB210 C25Yes No The screenshot below shows both formulas in action. The formula in D6 copied down is. You would by an apple only if it is Juicy and Red or Green.