Using a < and > together in a formula

#1

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

#2

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)))
#3

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
#4

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)))
#5

Thank you! That worked perfectly.