Formula to calculate numerical ranges in Excel

Asked

Viewed 160,740 times

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.

excel

2 answers

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;

FUNCTION IF

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

  • Hello @Sarafernandes Excel recognizes commas to separate decimals, you tried using commas, example: 25.5; 26.8 and etc...

  • Hello @abfurlan, my file is CSV type and my delimiter is "comma" so I use "dot" to separate decimals.

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")
  • 1

    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.