Funzione SE o PIU.SE con variabile testuale ERRORE 509

[incodemy]

Ho un problema con il SE.
Ho fatto questa funzione:

Codice: Seleziona tutto

=SE(A2={"B01";"B02";"B03";"B04";"B05";"B07";"B08";"B09";"B10";"B11";"B12";"B13";"B14";"B15";"B16";"B17";"B18";"B19";"C51";"C54";"C55";"C56";"C63";
"C66";"C67";"C70";"C71";"C74";"C75";"C76";"C77";"C78";"C79";"C80";"C81";"C82";"C83";"C84";"C85";"C86";"C87";"C95";"C96"})5%;

SE(E(A2={"C05";"C06";"C07";"C08";"C09";"C11";"C12";"C13";"C14";"C17";"C18";"C19";"C20";"C21";"C22";"C25";"C26";"C27";"C28";"C29";"C30";"C31";"C34";
"C35";"C36";"C37";"C38"})10%;

SE(E(A2={"C01";"C02";"C03";"C04";"C10";"C15";"C16";"C23";"C24";"C39";"C40";"C41";"C42"})18%;

SE(E(A2={"C43";"C44";"C45";"C46";"C47";"C48";"C49";"C50";"C52";"C57";"C58";"C59";"C60";"C61";"C62";"C64";"C65";"C68";"C69";"C88";"C89";"C90";"C91";
"C92";"C93";"C94";"D01";"D02";"D12";"D20";"D21";"D22";"D23";"D24";"D25";"D48";"D50";"D51";"D54";"D56";"D58";"D59";"D62";"D72"})15%;"mandante inesistente")))

ricevo errore 509
In pratica se nella cella A2 c'è il codice (ad esempio) B01, voglio il risultato 5% e così per tutti i gruppi di codice.

[Rafkus_pl]

Ho rimosso gli elementi tra {} ora vedi gli errori?

Codice: Seleziona tutto

=SE(A2={})5%;
	SE(E(A2={})10%;
	SE(E(A2={})18%;
	SE(E(A2={})15%;"mandante inesistente")))

[incodemy]

ricevo sempre errore 509

[incodemy]

L'ho fatta così su tuo suggerimento

Codice: Seleziona tutto

=SE(A2={"B01";"B02";"B03";"B04";"B05";"B07";"B08";"B09";"B10";"B11";"B12";"B13";"B14";"B15";"B16";"B17";"B18";"B19";"C51";"C54";"C55";"C56";"C63";"C66";"C67";"C70";"C71";"C74";"C75";"C76";"C77";"C78";"C79";"C80";"C81";"C82";"C83";"C84";"C85";"C86";"C87";"C95";"C96"})5%;SE(E(A2={"C05";"C06";"C07";"C08";"C09";"C11";"C12";"C13";"C14";"C17";"C18";"C19";"C20";"C21";"C22";"C25";"C26";"C27";"C28";"C29";"C30";"C31";"C34";"C35";"C36";"C37";"C38"})10%;SE(E(A2={"C01";"C02";"C03";"C04";"C10";"C15";"C16";"C23";"C24";"C39";"C40";"C41";"C42"})18%;SE(E(A2={"C43";"C44";"C45";"C46";"C47";"C48";"C49";"C50";"C52";"C57";"C58";"C59";"C60";"C61";"C62";"C64";"C65";"C68";"C69";"C88";"C89";"C90";"C91";"C92";"C93";"C94";"D01";"D02";"D12";"D20";"D21";"D22";"D23";"D24";"D25";"D48";"D50";"D51";"D54";"D56";"D58";"D59";"D62";"D72"})15%;"mandante inesistente")))

sempre errore 509

[Rafkus_pl]

un piccolo suggerimento invece di alcuni ")" deve essere ";"

Codice: Seleziona tutto

=SE(A2={};5%;
	SE(E(A2={});10%;
	SE(E(A2={});18%;
	SE(E(A2={});15%;"mandante inesistente"))))

[incodemy]

Rifatta così come mi hai detto tu:

Codice: Seleziona tutto

=SE(A2={"B01";"B02";"B03";"B04";"B05";"B07";"B08";"B09";"B10";"B11";"B12";"B13";"B14";"B15";"B16";"B17";"B18";"B19";"C51";"C54";"C55";"C56";"C63";"C66";"C67";"C70";"C71";"C74";"C75";"C76";"C77";"C78";"C79";"C80";"C81";"C82";"C83";"C84";"C85";"C86";"C87";"C95";"C96"};5%;SE(E(A2={"C05";"C06";"C07";"C08";"C09";"C11";"C12";"C13";"C14";"C17";"C18";"C19";"C20";"C21";"C22";"C25";"C26";"C27";"C28";"C29";"C30";"C31";"C34";"C35";"C36";"C37";"C38"};10%;SE(E(A2={"C01";"C02";"C03";"C04";"C10";"C15";"C16";"C23";"C24";"C39";"C40";"C41";"C42"};18%;SE(E(A2={"C43";"C44";"C45";"C46";"C47";"C48";"C49";"C50";"C52";"C57";"C58";"C59";"C60";"C61";"C62";"C64";"C65";"C68";"C69";"C88";"C89";"C90";"C91";"C92";"C93";"C94";"D01";"D02";"D12";"D20";"D21";"D22";"D23";"D24";"D25";"D48";"D50";"D51";"D54";"D56";"D58";"D59";"D62";"D72"};15%;"mandante inesistente")))

Errore #VALORE!

[Rafkus_pl]

Aspetta un attimo, manca ancora E()... o dovrebbe essere O() invece di E, perché come può un valore di A2 soddisfare più condizioni contemporaneamente?

Codice: Seleziona tutto

=SE(O(A2={}); 5%;
	SE(O(A2={}); 10%;
	SE(O(A2={}); 18%;
	SE(O(A2={}); 15%; "mandante inesistente"))))

controllare:

Codice: Seleziona tutto

=SE(O(A2={"B01";"B02";"B03";"B04";"B05";"B07";"B08";"B09";"B10";"B11";"B12";"B13";"B14";"B15";"B16";"B17";"B18";"B19";"C51";"C54";"C55";"C56";"C63";
"C66";"C67";"C70";"C71";"C74";"C75";"C76";"C77";"C78";"C79";"C80";"C81";"C82";"C83";"C84";"C85";"C86";"C87";"C95";"C96"});5%;
	SE(O(A2={"C05";"C06";"C07";"C08";"C09";"C11";"C12";"C13";"C14";"C17";"C18";"C19";"C20";"C21";"C22";"C25";"C26";"C27";"C28";"C29";"C30";"C31";"C34";
"C35";"C36";"C37";"C38"});10%;
	SE(O(A2={"C01";"C02";"C03";"C04";"C10";"C15";"C16";"C23";"C24";"C39";"C40";"C41";"C42"});18%;
	SE(O(A2={"C43";"C44";"C45";"C46";"C47";"C48";"C49";"C50";"C52";"C57";"C58";"C59";"C60";"C61";"C62";"C64";"C65";"C68";"C69";"C88";"C89";"C90";"C91";
"C92";"C93";"C94";"D01";"D02";"D12";"D20";"D21";"D22";"D23";"D24";"D25";"D48";"D50";"D51";"D54";"D56";"D58";"D59";"D62";"D72"});15%;"mandante inesistente"))))

Codice: Seleziona tutto

=PIÙ.SE(O(A2={"B01";"B02";"B03";"B04";"B05";"B07";"B08";"B09";"B10";"B11";"B12";"B13";"B14";"B15";"B16";"B17";"B18";"B19";"C51";"C54";"C55";"C56";"C63";"C66";"C67";"C70";"C71";"C74";"C75";"C76";"C77";"C78";"C79";"C80";"C81";"C82";"C83";"C84";"C85";"C86";"C87";"C95";"C96"});5%;
	O(A2={"C05";"C06";"C07";"C08";"C09";"C11";"C12";"C13";"C14";"C17";"C18";"C19";"C20";"C21";"C22";"C25";"C26";"C27";"C28";"C29";"C30";"C31";"C34";"C35";"C36";"C37";"C38"});10%;
	O(A2={"C01";"C02";"C03";"C04";"C10";"C15";"C16";"C23";"C24";"C39";"C40";"C41";"C42"}); 18%;
	O(A2={"C43";"C44";"C45";"C46";"C47";"C48";"C49";"C50";"C52";"C57";"C58";"C59";"C60";"C61";"C62";"C64";"C65";"C68";"C69";"C88";"C89";"C90";"C91";"C92";"C93";"C94";"D01";"D02";"D12";"D20";"D21";"D22";"D23";"D24";"D25";"D48";"D50";"D51";"D54";"D56";"D58";"D59";"D62";"D72"});15%;
	1; "mandante inesistente")

[incodemy]

Codice: Seleziona tutto

=SE(O(A2={}); 5%;
	SE(O(A2={}); 10%;
	SE(O(A2={}); 18%;
	SE(O(A2={}); 15%; "mandante inesistente"))))

CORRETTO!!
Finalmente funziona! Non hai idea di quanto sia felice e quanto vorrei stringerti la mano e offrirti una cena!
Sei fantastico!

Grazie!