How to add if() arguments in column formular?

[bouhme]

Hey there,
I try to add more the on if() argument in a formular to add several results .
I write down in the formular of the summery column :
IF([S1A] >[S1B], [S1A] -[S1B], 0)
and it works. But the volleyball teams plays more than one set. So i would write:
IF([S1A] >[S1B], [S1A] -[S1B], 0) + IF([S2A] >[S2B], [S2A] -[S2B], 0)
an so on for 3 and more sets. But this doesn´t work and i get an error massage.
So is there a way to do this in one formular?

Thanks and hope for your help

[LeventK]

@bouhme what error message are you receiving?

[bouhme]

bouhme:

• IF([S2A] >[S2B], [S2A] -[S2B], 0)

Oh sorry.
first i try it and get error massages like :
expression not right or more than one expression are not allowed for this argument.
But when i now copy my sample i wrote here every thing went ok.

I don´t understand why it is now working but i´m happy also:

Sorry for that and thank you very much for your help

[Aleksi]

More simple way could be the expression IFS like…
IFS([S1A]>[S1B],[S1A]-[S1B]) + IFS([S2A]>[S2B],[S2A]-[S2B])+etc.