FAQ

When using AND, the most common questions fall into 3 groups: formula errors, unexpected results, and applying the formula across multiple cells.

FAQ

What should I do if AND shows an error after I enter it?

1. Check whether the formula starts with an equals sign =.
2. Make sure parameters are separated with English commas instead of full-width punctuation.
3. Check whether each condition expression is complete, including operators and cell references.
4. Edit the formula and press Enter again.

Why does the AND result not match what I expected?

1. Check each condition one by one to confirm whether all of them are true.
2. Confirm that referenced cells contain the expected data type, such as numbers instead of text.
3. If AND is combined with IF or another function, review both the AND part and the outer formula.
4. If needed, test each condition in a separate cell first.

How can I use AND in multiple cells at once?

1. Enter the correct AND formula in the first target cell.
2. Select that cell and move the pointer to the fill handle in the lower-right corner.
3. Drag down or across to copy the formula to other cells.
4. Check whether $ is needed to lock references.

Glossary