Error: the number of arguments is not correct for this function

[kjell syryn]

When creating a Expression with 2 IFS i get the error "the number of arguments is not correct for this function". What dose this mean and how can i solve this

[Barry Kelly · Accepted solution]

Make sure it is following the correct format.

IFS(argument_1, result_1, argument_2, result_2, argument_3, result_3)

You can add as many arguments/results as you want.

Barry.

[Jimmzs]

Hi, I'm getting the same error and I think the syntaxis is ok. Can you help me with this?

Jim

 

[Barry Kelly]

What happens when you remove the last ... ,0

It is not part of the argument.

Barry.

[Xandros]

As additional information:

if you like to add a result (0 in your expression), if none of the other conditions are met, you can do it by adding a TRUE as last argument:

IFS ( TRANSECTO = "T3", 3, TRANSECTO = "T4", 4, TRANSECTO = "T5", 5, TRUE, 0 )

[Jimmzs]

Thank you so much. Indeed I wanted the "0" as the result if any of the conditions were true.