---
title: "CASE"
description: "CASE"
keywords: "CASE"
url: "https://myrapidi.com/wiki/case"
locale: "en"
published: "2009-05-15T06:19:43Z"
modified: "2025-01-13T12:06:58Z"
---

The ##CASE formula is used to evaluate an input value against a series of cases (conditions) and return a corresponding result. It's similar to a **switch-case** statement in programming or a series of **if-else** conditions, providing a compact and readable way to map values.  
  
The syntax would be : **##CASE (fields, value1, result1, value2, result2, default result)**;

**Example:**

```
##CASE("Departmentcode", 'East', 1, 'Vest', 2, 'North', 3, 99)
```

**Formula breakdown:**

1. **"Departmentcode"** : The value being evaluated (e.g., a department code string).
2. **Cases and Results** :
  - 'East' → 1
  - 'Vest' → 2
  - 'North' → 3

3. **Default Result** : 99 (returned if none of the cases match).

The ##CASE formula can be also used in combination with other formulas such as ##DBLOOKUP, #ISEMAIL, #ISPHONE, etc. Here are a couple of additional examples:

```
##CASE(ISEMAIL("E-Mail"),1,"E-Mail",SKIPFIELD())
```

```
##CASE(ISPHONE(PrimaryContactPhone),1,PrimaryContactPhone,SKIPFIELD())
```