Forum Discussion
pedrojas3ki
Jan 19, 2019Copper Contributor
Hi! I need help with a range from Negative to positive
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.
- Detlef_LewinSilver Contributor
Hello
=IF(MEDIAN(O3,R17,S17)=O3,"OK","NOT OK")
=IF(OR(O3<=R17,O3>S17),"OK","NOT OK")Untested.