Jan 18 2019 06:42 PM
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.
Jan 18 2019 10:58 PM
Hello
=IF(MEDIAN(O3,R17,S17)=O3,"OK","NOT OK")
=IF(OR(O3<=R17,O3>S17),"OK","NOT OK")
Untested.