Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
AND
AND evaluates several logical conditions and returns TRUE only if all of them hold. It is most useful nested inside IF to require multiple criteria at once.
Excel
=AND(A2>0, B2>0)Google Sheets
=AND(A2>0, B2>0)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| X | Y |
| 5 | 8 |
=AND(A2>0, B2>0)→TRUE
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1A2>0 and B2>0 are the conditions.
- 2AND is TRUE only when both are true.
- 35 and 8 are both positive, so the result is TRUE.