Forum Discussion

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...

Formulas and Functions

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.

Gold Contributor

Sep 16, 2020

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.

Copper Contributor

Sep 16, 2020

Wonderful thanks so much mathetes ! It perfectly works 🙂

Resources