Multiple function - EXCEL

[aurelieg]

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 !

[#2 · Accepted 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.

[#3]

Wonderful thanks so much @mathetes ! It perfectly works :)

[#4]

@aurelieg 

Or:

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