SWITCH Function SYNTAX

[Elio]

Hi i'm new in the forum, thank you in advance.

I'm tryng to use Switch function but it gives me back Syntax error.


And i can't find the problem.
Somebody can help me?

Switch(
[DN]<32, "Art 4.3",
[DN]>32 and 0<[DN*PS]<1000 ), "Art 4.3",
32<[DN]<100 and 1000<[DN*PS]<3500 , " Cat 1",
100<[DN]<250 and 3500<[DN*PS]<5000 , " Cat 2",
[DN]>250 and [DN*PS]>5000 , " Cat 3"
)

He says:
The Expression you entered contains invalid syntax.
You may have entered an operand without an operator.

[June7]

You have a field named DN*PS

Really should not use punctuation/special characters (underscore only exception) in naming convention.

Maybe:
Switch([DN]<32 Or ([DN]>32 And 0<[DN*PS] And [DN*PS]<1000), "Art 4.3",
32<[DN] And [DN]<100 And 1000<[DN*PS] And [DN*PS]<3500 , "Cat 1",
100<[DN] And [DN]<250 And 3500<[DN*PS] And [DN*PS]<5000 , "Cat 2",
[DN]>250 and [DN*PS]>5000, "Cat 3"
)