Home

Hi! I need help with a range from Negative to positive

%3CLINGO-SUB%20id%3D%22lingo-sub-321132%22%20slang%3D%22en-US%22%3EHi!%20I%20need%20help%20with%20a%20range%20from%20Negative%20to%20positive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321132%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20i%20try%20to%20do%20this%3A%3C%2FP%3E%3CP%3E%3DSI(Y(O3%26lt%3B%3DR17%2C%20O3%26gt%3BS17)%3B%20%22Aceptado%22%3B%20%22Rechazado%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ereturns%20me%20the%20error%20%22trying%20to%20write%20a%20formula%22.%3C%2FP%3E%3CP%3EAll%20i%20need%20to%20do%20is%20to%20say%20thet%20if%20a%20value%20(i.e.%206.3)%20is%20between%20-15%20to%2015%2C%20that%20value%20is%20aceptable%2C%20if%20not%2C%20reject%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHelp%20me%20please.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-321132%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321143%22%20slang%3D%22en-US%22%3ERe%3A%20Hi!%20I%20need%20help%20with%20a%20range%20from%20Negative%20to%20positive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321143%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%3DIF(MEDIAN(O3%2CR17%2CS17)%3DO3%2C%22OK%22%2C%22NOT%20OK%22)%3CBR%20%2F%3E%3CBR%20%2F%3E%3DIF(OR(O3%26lt%3B%3DR17%2CO3%26gt%3BS17)%2C%22OK%22%2C%22NOT%20OK%22)%3C%2FPRE%3E%3CP%3EUntested.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
pedrojas3ki
Occasional Visitor

When i try to do this:

=SI(Y(O3<=R17, O3>S17); "Aceptado"; "Rechazado")

 

returns me the error "trying to write a formula".

All i need to do is to say thet if a value (i.e. 6.3) is between -15 to 15, that value is aceptable, if not, reject

 

Help me please.

1 Reply
Highlighted

Hello

 

=IF(MEDIAN(O3,R17,S17)=O3,"OK","NOT OK")

=IF(OR(O3<=R17,O3>S17),"OK","NOT OK")

Untested.