Forum Discussion

aurelieg's avatar
aurelieg
Copper Contributor
Sep 16, 2020
Solved

Multiple function - EXCEL

 

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 !

 

excel
Excel on Mac
Formulas and Functions
office 365
  • mathetes's avatar
    mathetes
    Sep 16, 2020

    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 Replies

  • mathetes's avatar
    mathetes
    Gold Contributor
    Sep 16, 2020

    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.

Resources