I'm creating a check to see if the weight value is 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 it always returns
# N / A
Thank you for helping.
The error is in the way you are testing with 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)
By analyzing your formula, it would look something like this, using the test 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 put >= , because the way it was would not give the result if the weight was exactly 30, for example.
See another example here: