Home

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

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

Hello

 

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

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

Untested.

 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies