Excel SES returning #N/D

Asked

Viewed 51 times

1

I’m creating a check to see if the value of heaviness this between:

=SES(FRETES!$I$3>1<30;21,75;FRETES!$I$3>31<50;27,91;FRETES!$I$3>51<70;35,54;FRETES!$I$3>71<100;47,72;FRETES!$I$3>101<150;76,27;FRETES!$I$3>151<200;116,01;FRETES!$I$3>201;0)

But always returns

#N/D

I thank anyone who can help.

excel

  • Says James, if the answer below answered do not forget to mark as the answer to your question to help others in the future.

1 answer

2

The error is in the way you are testing with the SES():

=SES(FRETES!$I$3>1<30....

The correct formatting of SES() would be:

=SES(VALOR_TESTADO=VALOR_1;RESULTADO_1;VALOR_TESTADO=VALOR_2;RESULTADO_2)

Analyzing its formula, it would look something like this, using in the test the E():

=SES(E(FRETES!$I$3>1;FRETES!$I$3<30);21,75;E(FRETES!$I$3>=30;FRETES!$I$3<50);27,91)

Please note that I have put the >=, because the way I was would not give the result if the weight was exactly 30, for example.

See another example here:

http://excelguru.com.br/excel-2/novas-funcoes-excel-365/

  • Thank you, I’ll take the test.

  • Evert, you’re a beast!

  • =) Valeu Leandro!!

Browser other questions tagged excel

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