Help

Help with an if then concatenated formula

Topic Labels: Formulas
Solved
Jump to Solution
2916 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Jose_Alberto_Fu
6 - Interface Innovator
6 - Interface Innovator

For a casting agency db I need to set a personalized filter column

I have a field with the age, now I need a formula column that gives me the segment :point_down:t2:

AGE CALCULATED COLUMN
< 15 kids
=> 15 & < 18. teenagers
=> 18 & < 31 young
=> 31 & < 45 mature
=> 45 older

I’ve been trying to make an if then concatenated formula but I’m always getting errors.

Any help? :pray:

1 Solution

Accepted Solutions

i think, it’s quotes, the forum substituted usual symmetric single quote
by left/right quotes…
my fault, i should have select formula text to avoid it.
correct version (substitute only lower part, with quotes)

Switch(
(age>15)+(age>18)+(age>31)+(age>45)

,0,'kids'
,1,'teenagers'
,2,'young'
,3,'mature'
,4,'older'
)

See Solution in Thread

4 Replies 4

Switch(
(age>15)+(age>18)+(age>31)+(age>45)
,0,‘kids’
,1,‘teenagers’
,2,‘young’
,3,‘mature’
,4,‘older’
)

Thanks Alexey.

I’m getting an error. Maybe am I missing something?

image

i think, it’s quotes, the forum substituted usual symmetric single quote
by left/right quotes…
my fault, i should have select formula text to avoid it.
correct version (substitute only lower part, with quotes)

Switch(
(age>15)+(age>18)+(age>31)+(age>45)

,0,'kids'
,1,'teenagers'
,2,'young'
,3,'mature'
,4,'older'
)

I see! Thanks so much. It works like a charm! :grinning: