[SOLVED] multiple IF solution.

[yadepvi]

Hi everyone,

I did this formula in google sheet.

Code: Select all

=IFS(D2="Ciencia ficción","C2FI",D2="Películas 5*1","AAF",D2="Películas 5*2","AAM",D2="Películas 5*3","AAP",D2="Col Tim Burton","C1FI",D2="Vampiros y superheroes","C1FD",D2="Terror","C1FC",D2="Españolas 1","C1AI",D2="Españolas 2","C1AD",D2="Españolas 3","C1AC",D2="Col Stanley Kubrick","C2FI",D2="Manga","C2FD",D2="Intriga","C2FD",D2="Animación","C2FD",D2="Comedia","C2FC",D2="Romance","C3FC",D2="Musical","C2AI",D2="Acción","C2AD",D2="Drama 1","C2AC",D2="Western","C3FI",D2="B/N","C3FI",D2="Aventura","C3FD",D2="Drama 2","C3AI",D2="Basada hechos reales","C3AD",D2="Deporte","C3AD",D2="Documental","C3AC",D2="Thriller","C1FC",D2="Col Hitchcock","AIB",D2="Col Pais","AIA")

I don't know how to solve it in Calc.

I tried with IF and LOOKV but was not solved.

Thanks.

[Zizi64]

Please upload an .ods type sample file here.

[thinman3]

Calc uses a ( ; ) separator instead of a ( , ).

I used the attached file to verify that all the required IF requirements were being found. Your original formula was edited to replace the ( , )'s with ( ; )'s . The formula that is in A2 of the attached file shows the modifications with respect to the separators. It can be used to replace your original formula.

Movie Genre's.ods

(17.22 KiB) Downloaded 99 times

[RusselB]

Try saving your Google sheet using the OpenDocument format, which is what OpenOffice uses by default, then opening your spreadsheet in OpenOffice.

[yadepvi]

Thanks, solved!

Calc uses a ( ; ) separator instead of a ( , ).

I used the attached file to verify that all the required IF requirements were being found. Your original formula was edited to replace the ( , )'s with ( ; )'s . The formula that is in A2 of the attached file shows the modifications with respect to the separators. It can be used to replace your original formula.

Movie Genre's.ods