Support Board

Date/Time: Thu, 25 Apr 2024 09:51:22 +0000

[User Discussion] - FORMULA => TRUE IF NUMBER IS BETWEEN 10 AND 20

[2013-04-19 09:29:37] #1 [Go To First Post]
kam2001 - Posts: 65
TRUE IF AA3 IS BETWEEN 10 AND 20 AND E3 > B3 How to write the above formula in spreadsheet Date Time Of Last Edit: 2013-04-19 09:34:01

[2013-04-19 10:47:07] #2 [Go To First Post]
FGBL07 - Posts: 19
=AND(AA3<=20,AA3>=10,E3>B3) If you do not want to include the limits 10 and 20 use "<" instead of "<=" resp. ">" instead of ">=".

To post a message in this thread, you need to log in with your Sierra Chart account: