IFS function and Cell with a local menu format


Hello

I have a problem with IFS function ( or IF ) :



When I select a line from the pop-up menu (made from the list of months of the year)... I want a cell of another table to be automatically completed according to the chosen value :


example :


If I take janvier--->. it writes 01 in the target cell


If I take mars --->. it writes 03 in the target cell



It seems that NUMBERS is not able to process a formula using the IFS function when referring to an array whose cell is in the "local menu" format.


IFS('Tableau 2-1'::A1="janvier";"01";'Tableau 2-1'::A1="fevrier";"02";'Tableau 2-1'::A1="mars";"03")


can you help me :-)





Posted on Nov 27, 2023 1:21 AM

Reply
17 replies

Nov 27, 2023 6:08 AM in response to Recycleur

thank you @Recycleur


  • in French files the name of IFS is SIS ... not SI.CONDITIONS who is not recognize.


  • the French formule below never work : :-/
SIS('Tableau 2-1'::A1="janvier";"01";'Tableau 2-1'::A1="fevrier";"02";'Tableau 2-1'::A1="mars";"03")



This other formula doesn't work better :


SI('Tableau 2-1'::A1="janvier";"01";"YESS";"Noooooo")



Too bad!

Nov 27, 2023 6:25 AM in response to frenchpetzouille

Well, I learned something new today.


In French (Canada), we use SI.CONDITIONS


I couldn't imagine that the same language would name the same function differently in another country, as in French (France)

SIS('Tableau 2-1'::A1="janvier";"01";'Tableau 2-1'::A1="février";"02")


Obviously

SI('Tableau 2-1'::A1="janvier";"01";"YESS";"Noooooo")

doesn't work because it has four arguments, whereas SI only uses three.


It would help to click on the red error triangle and read the error message. Is SIS not working (what does "not working" mean anyway?) because of a syntax error or because of a data error? The formula I posted above works for me, but gives an error if 'Tableau 2-1'::A1="janvier" is empty. You may have a bad cell reference. Error message: SIS requiert au moins une condition VRAI, mais aucune n’a été trouvée.

Nov 27, 2023 6:46 AM in response to Recycleur

Obviously
SI('Tableau 2-1'::A1="janvier";"01";"YESS";"Noooooo")
doesn't work because it has four arguments, whereas SI only uses three.

you're right ++ ... I made a mistake


But if I transform the formula by putting this, it doesn't work better :


SI('Tableau 2-1'::A1="janvier";"YESS";"Noooooo")


The cell of the table of 2-1 is formatting like pop-up menu as indicated on the screen copy of my first message.

Maybe that's what doesn't work ( I always have ' Noooooo' in the target cell )

IFS function and Cell with a local menu format

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.