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?
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.
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
Do you mean that you're using the formula in conditional formatting? It is not possible to use an array {...} in a conditional formatting formula.