expression error

[peppemigl]

Hi all,

I have a huge problem in which I'm stuck and I'll explain to you hoping that someone can give me a hand.

I need to create a control on several inserted fields and have a result.

I explain :

- I have a field named "season" which can take on two values -- ( Hight and Low) 

- if the value is "high" I have to check the "room" field 

- for each room it gives me a numerical value

- different from the season loss

I have try with : 

IF (

AND([SEASON]="hight",

IFS([room]="double",100,[room]="triple",200,[room]="quad",300) ),0)

But it doesn't work...how can i do it if i want to chain?

IF(..IF(..IF(..)))

[Landan_QREW · Accepted solution]

I may try the following:

IF (

AND([SEASON]="hight", IN([room],{'double','triple','quad'})),

IFS([room]="double",100,[room]="triple",200,[room]="quad",300),

0

)

[Aurelien]

---

@peppemigl wrote:

how can i do it if i want to chain?

---

Hi @peppemigl 

I would suggest to mix together IFS() and AND()

[Landan_QREW · Accepted solution]

I may try the following:

IF (

AND([SEASON]="hight", IN([room],{'double','triple','quad'})),

IFS([room]="double",100,[room]="triple",200,[room]="quad",300),

0

)

[peppemigl]

fantastic , 

IFS([room]="double",100,[room]="triple",200,[room]="quad",300),

0) 

it's possible to insert another AND e IFS for season "loss"?

[Landan_QREW]

replace the 0 with another IF() or IFS() expression.

[Landan_QREW · Accepted solution]

IF (

AND([SEASON]="hight", IN([room],{'double','triple','quad'})),

IFS([room]="double",100,[room]="triple",200,[room]="quad",300),

IF (

AND([SEASON]="loss", IN([room],{'double','triple','quad'})),

IFS([room]="double",100,[room]="triple",200,[room]="quad",300),

0

)

)

[peppemigl]

thanks so much😊