10
I need some help to make a formula in Excel.
=SE(C11<=6;"G4";SE(6<C11<=10;"G6";SE(10<C11<=16;"G10")))
What I want to do is:
If the cell C11 is less than or equal to 6 write G4.
If the cell C11 is greater than 6 and less than or equal to 10 write G6.
If the cell C11 is greater than 10 and less than or equal to 16 write G8.
17
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 returns true to the first SE and writes G4.
When you’re 6, test the second SE, if it is less than or equal 10 returns true and writes G6.
When bigger than 10, test the third SE, if less than or equal to 16 write G8.
Or you write FALSO;
0
Or so to avoid many "IF":
=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")
In your answer you have an "IF" more than in the question and in the other answer. Why do you say that so "avoids" many "IF"?
Browser other questions tagged excel
You are not signed in. Login or sign up in order to post.
Hello, good afternoon, sir! I did the function and it worked, but my range of intervals contains decimal numbers, for example: 25.5, 26.8 etc, and Excel did not identify decimal values.
– Sara Fernandes
Hello @Sarafernandes Excel recognizes commas to separate decimals, you tried using commas, example: 25.5; 26.8 and etc...
– abfurlan
Hello @abfurlan, my file is CSV type and my delimiter is "comma" so I use "dot" to separate decimals.
– Sara Fernandes