Login Page - Create Account

Support Board


Date/Time: Mon, 06 May 2024 07:01:31 +0000



Post From: Alerts: If Then Else Construct?

[2018-06-29 19:47:02]
Xfanman1 - Posts: 320
es, you just have to string multiple IF statements together. This is the same way you would do it in Excel.

For example, if A > B then 1, else if B > C, then 2, else 0 would be written as:
=IF(A > B, 1, IF(B > C, 2, 0))

All this time I've been under the mistaken impression I couldn't use IF statements in Simple Alerts. Good to know going forward.

--
Scott
Date Time Of Last Edit: 2018-06-29 19:47:13