I need to create a formula that does this:

Attendee Count < 100 put in 1

Attendee Count > 201 < 1000 put in 2

Attendee Count > 1001 < 5000 put in 3

Attendee Count > 5001 put in 4

I need to create a formula that does this:

Attendee Count < 100 put in 1

Attendee Count > 201 < 1000 put in 2

Attendee Count > 1001 < 5000 put in 3

Attendee Count > 5001 put in 4

For this you’ll need to nest a series of IF operations, also using AND to combine some pieces. (I’m also guessing that “201” should be “101” in your example above.)

```
IF({Attendee Count} < 100, 1,
IF(AND({Attendee Count} > 100, {Attendee Count} <= 1000), 2,
IF(AND({Attendee Count} > 1000, {Attendee Count} <= 5000), 3, 4)))
```

You don’t actually need the ANDs in there if the IF statements are ordered correctly. This should be fine:

IF({Attendee Count} < 100, 1,

IF({Attendee Count} <= 1000, 2,

IF({Attendee Count} <= 5000, 3, 4)))

2 Likes

Good point! It could also be done in reverse order:

```
IF({Attendee Count} > 5000, 4,
IF({Attendee Count} >= 1000, 3,
IF({Attendee Count} >= 100, 2, 1)))
```