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?
The following might work. But you might have to experiment with the list separators for your language.
PIU'.SE(O(A1={5;7;10;1});"errore";"no errore")
-----
Traduzione di Google:
Quanto segue potrebbe funzionare. Ma potresti dover sperimentare i separatori di elenco per la tua lingua.
Thank you JoeUser2004 ! I have to try now!! I'll respond to you!
- Hello Joe, It didn't work.
For example using this formula gives me another error=PIÙ.SE(VAL.NUMERO(RICERCA(O("cucina";"Bagni");A13));16) Do you know any other solution? In the former case, I used curly brackets.- No...It still saying it contains an error. A13 cell doesn't come out with the blue color. So there should be some lack of punctuation or the formula needs a modification