Forum Discussion
Solved
OR(=)
Is there a way to type faster this PIU'.SE(O(A1=5;A1=7;A1=10;A1=1);"errore")like this : PIU'.SE(A1=O(5;7;10;1);"errore"=)?
Can you provide a workbook instead of a screenshot?
PIÙ.SE(E(R66=35;O(A66={"Gennaio"\"Febbraio"\"Marzo"\"Ottobre"\"Novembre"\"Dicembre"});S66=1);6,3;E(R66=45;AA3=1);4,8;E(R66=55;O(A66={"Gennaio"\"Febbraio"\"Marzo"\"Ottobre"\"Novembre"\"Dicembre"});S66=1);3,73;E(R66=35;O($A$66={"Aprile"\"Maggio"\"Giugno"\"Luglio"\"Agosto"\"Settembre"});S66=1);5,65)@Hans Vogelaar
Is still giving error. like N/D
The problem is that although S3 displays 1, its value is actually not equal to 1, but to 1,130815...
You'll see this if you set the number format of S3 to General:
You might use ARROTONDA(S3;0) instead of S3 in the formula. See the attached version.