AND OR
Combine tests.
- Snippet
- Conditions and counting
- 2 blanks to fill
=IF(AND(Test 1, Test 2), "Both", IF(OR(Test 1, Test 2), "One", "Neither"))
Orange words are blanks you have not filled yet. Press ⌘ Return to copy.
About this template
Combine tests.
- Category
- Spreadsheet formulas
- Pack
- Conditions and counting
- Type
- Snippet, a short message
- Asks for
- Test 1, Test 2
Use it anywhere you write: email, chat, a document or a support tool. If you send it often, save the finished text as a snippet in ClipBuddy and paste it again from your clipboard history with ⌘⇧V.
Template source
The template as written, with its blanks in double braces, such as {{Name}}.
=IF(AND({{Test 1}}, {{Test 2}}), "Both", IF(OR({{Test 1}}, {{Test 2}}), "One", "Neither"))