Wrong Return on SE function

Asked

Viewed 33 times

0

=SE(C5<=3,09;"0,15%";SE(C5<=3,1--4,99;"0,20%";SE(C5>=5;C5;"0,30%")))

is returning wrong value in the last function

inserir a descrição da imagem aqui

excel
  • 2

    What do you mean by this condition: C5<=3.1--4.99? Maybe you want: E(C5>=3.1; C5<=4.99)

  • THEN IT WAS LESS EQUAL TO 3.1 TO 4.99 TO RETURN 0.30%

  • Greater than or equal to 3.1 and less than or equal to 4.9 returns "0.20%".

  • Note that in your last SE will never be displayed the result "0.30%".

  • Maybe you should describe what you want to do and the formula used and what you think is wrong.

  • CORRECTING THE FORMULA AND THAT

  • =SE(C5<=3,09;"0,15%";SE(C5<=3,1--4,99;"0,20%";SE(C5>=5;"0,30%")))

  • I WANT IT TO RETURN 0.30% WHEN IT RETURNS 5 BUT IT DOES NOT RETURN 0.30 FROM 8

  • 1

    =SE(C5<=3,09;"0,15%";SE(C5<=3,1;"0,20%";SE(C5<=4,99;"0,20%";SE(C5>=5;"0,30%"))) VALEI JA FOUND A WAY TO WORK

Show 4 more comments

1 answer

1

Try to put the references cells. So we can help you...

In all cases try the following:

SE(C5<=3,09;"0,15%";SE(C5<=3,1;"0,20%";SE(C5<5;"0,20%";SE(C5>=5;"0,30%"))))

Thus it is possible to contemplate all values less than 5

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.