Login Page - Create Account

Support Board


Date/Time: Thu, 26 Apr 2018 15:35:20 +0000



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

Support Request:
[2013-04-19 09:29:37]
kam2001 - Posts: 12
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]
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 ">=".
[2013-04-19 18:07:01]
kam2001 - Posts: 12
Thank you :)

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

Login


Login Page - Create Account