SOLVED

Multiple function - EXCEL

%3CLINGO-SUB%20id%3D%22lingo-sub-1675044%22%20slang%3D%22en-US%22%3EMultiple%20function%20-%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1675044%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22thread-message-content-body-text%20thread-full-message%22%3E%3CP%3EHi%20!%3C%2FP%3E%3CP%3EI'm%20trying%20a%20multiple%20fonction%20with%20IF%20but%20it%20doesn't%20work.%20The%20result%20I'm%20trying%20to%20get%20is%20%3A%3C%2FP%3E%3CP%3E-%20IF%20G2%20%3D%20%26gt%3B%2040%20%3B%20%22Dock%22%3C%2FP%3E%3CP%3E-%20IF%20G2%20%26lt%3B%2040%20%3B%20%22CF%22%3C%2FP%3E%3CP%3E%3D%20IF%20G2%20%3D%20%26lt%3B%2011%20%3B%20%2211%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20several%20things%20as%20%3A%3C%2FP%3E%3CP%3E%3DIF(G2%3D%26gt%3B40%3B%22Dock%3B%22CF%22%2CIF(G2%3D%26lt%3B11%3B%2211%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20that%20it%20blocks%20because%20Excel%20may%20think%20that%20there%20are%202%20possibilities%20under%2040%20but%20in%20fact%20I%20want%20%22CF%22%20between%2012%20and%2039%20and%20%2211%22%20between%201%20and%2011.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20your%20help%20!%3C%2FP%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1675044%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1675078%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20function%20-%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1675078%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F796261%22%20target%3D%22_blank%22%3E%40aurelieg%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20will%20work.%20It%20uses%20the%20IFS%20function%20rather%20than%20nested%20IF%20functions.%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DIFS(G2%26gt%3B%3D40%2C%22Dock%22%2CG2%26lt%3B%3D11%2C%2211%22%2CG2%26gt%3B11%2C%22CF%22)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%20me%20know%20of%20any%20questions.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1675149%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20function%20-%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1675149%22%20slang%3D%22en-US%22%3E%3CP%3EWonderful%20thanks%20so%20much%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B!%20It%20perfectly%20works%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

 

Hi !

I'm trying a multiple fonction with IF but it doesn't work. The result I'm trying to get is :

- IF G2 = > 40 ; "Dock"

- IF G2 < 40 ; "CF"

= IF G2 = < 11 ; "11"

 

I tried several things as :

=IF(G2=>40;"Dock;"CF",IF(G2=<11;"11")

 

I think that it blocks because Excel may think that there are 2 possibilities under 40 but in fact I want "CF" between 12 and 39 and "11" between 1 and 11.

 

Thanks in advance for your help !

 

3 Replies
Highlighted
Best Response confirmed by aurelieg (New Contributor)
Solution

@aurelieg 

 

This will work. It uses the IFS function rather than nested IF functions.

=IFS(G2>=40,"Dock",G2<=11,"11",G2>11,"CF")

 

Let me know of any questions.

Highlighted

Wonderful thanks so much @mathetes ! It perfectly works

Highlighted

@aurelieg 

Or:

=LOOKUP(G2,{0;12;40},{11;"CF";"Dock"})