I am not a very experienced user of Calc but I have set up a spreadsheet to control scores from skittle matches
I use the following =IFS(E3>F3,3,F3>E3,0,F3=E3,1,) to determine whether it has been a home or away win or a draw. The scores go into E3 and F3
The problem is all the un-played matches show as draws because E3 and F3 equal each other even if the cells are empty
Is there a way of using IFS, or some other expression, so as to ignore empty cells?
Thank you in advance
=POWER(2;SIGN(E3-F3)+1)-1
subtracts 1 from 1, 2 or 4
Which still results in 1 if both E3 and F3 are empty.
=IF(COUNT(E3;F3)=2;POWER(2;SIGN(E3-F3)+1)-1;"-")
If both cells are numeric subtract 1 from 1, 2 or 4, else return some string
=IFS(E3>F3;3;F3>E3;0;AND(NOT(ISBLANK(E3));F3=E3);1)
Btw, in your expression was a trailing omitted parameter that is useless with IFS(), default omitted value is 0 so when evaluated as condition just yields another FALSE.
Many thanks for the solutions but neither seems to work well, is there some way to upload the spreadsheet so you can see the problem?
I have attached my spreadsheet so you can see the problem, sorry to be a nuisance but your advice is much appreciated
Data Skittles2022-2023.ods (69.0 KB)
Cell G3
=IF(COUNT($E3:$F3)=2;IFS($E3>$F3;3;$F3>$E3;0;$F3=$E3;1);"-")
Possibly you are interested in a ready made solution:
Bundesliga_forum.odb (115.4 KB) (German Soccer) Open the forms “Matches” and “Seasons_Clubs”
That now works beautifully, thank you so much for your help 
The classical case of “ask an incomplete question, get an incomplete answer”.