Forum Discussion

pedrojas3ki's avatar
pedrojas3ki
Copper Contributor
Jan 19, 2019

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_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    Hello

     

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

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

    Untested.

     

     

Resources