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

Copper Contributor

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

Hello

 

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

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

Untested.