I need some help to make an Excel formula.
=SE(C11<=6;"G4";SE(6<C11<=10;"G6";SE(10<C11<=16;"G10")))
What I want to do is:
If the C11 cell is less than or equal to 6, type G4 .
If the C11 cell is greater than 6 and less than or equal to 10 write G6 .
If the C11 cell is greater than 10 and less than or equal to 16 write G8 .
You need to use SE nested
=SE(C11<=6;"G4";SE(C11<=10;"G6";SE(C11<=16;"G8";"FALSO")))
In this case it will test the conditions one at a time, when it is less than or equal to 6 it returns true for the first SE and writes G4 .
When greater than 6, test the second SE , if less than or equal 10 returns true and writes G6 .
When it is greater than 10, it tests the third SE , if it is less than or equal to 16 writes G8 .
Otherwise it writes FALSO ;
Or so to avoid many "SEs":
=se(C11<=6;G4;se(e(C11>6;C11<=10);G6;se(e(C11>10;C11<=16);G8;se(C11>16;"Valor foi maior que 16")