[TRNSYS-users] "if" function in trnsys

To: trnsys-users@lists.onebuilding.org
Subject: [TRNSYS-users] "if" function in trnsys
From: Rm Chemilo via TRNSYS-users <trnsys-users@lists.onebuilding.org>
Date: Fri, 21 Apr 2017 14:53:11 +0900
Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=0dM2fGgzo4LldLXMDGe1OCKOZIZ6der3ArJBOQ5rBS4=; b=Zb1nKu882H2Eqq22hJ8kDHB51Pagpbxajnga+mli54G9aPLUKwjllgSsqQV6pXXl++ ExjFSiBqG6RIjGh8yNADDdxVcDl08bFGBmtaGdbvXjeZTGabBpdMb/SJD/gJr83ZvR3P dRg3YIuYF9gUWxSlE8IDaZKEbxpoDddc39xUsuKByDWRd7fNKg9G48UdQLKhq7PBZ/zm rjgwGk1GnyGpC8C6zHNJ/o1aoHl/hYHc46iBixf5tmSd1AkYslMUNAV5wF6PIGozSOFB /Q5ws9HQXiBiP9pvCyGSfOq+jamO8rAaoJPKTI1wyS879ADywA6SlaAwr5MK1ndUT57U GvJQ==
List-archive: <http://lists.onebuilding.org/pipermail/trnsys-users-onebuilding.org/>
List-help: <mailto:trnsys-users-request@lists.onebuilding.org?subject=help>
List-id: "TRNSYS users mailing list at OneBuilding.org" <trnsys-users-onebuilding.org>
List-post: <mailto:trnsys-users@lists.onebuilding.org>
List-subscribe: <http://lists.onebuilding.org/listinfo.cgi/trnsys-users-onebuilding.org>, <mailto:trnsys-users-request@lists.onebuilding.org?subject=subscribe>
List-unsubscribe: <http://lists.onebuilding.org/options.cgi/trnsys-users-onebuilding.org>, <mailto:trnsys-users-request@lists.onebuilding.org?subject=unsubscribe>
Reply-to: Rm Chemilo <chemilo92@gmail.com>, "TRNSYS users mailing list at OneBuilding.org" <trnsys-users@lists.onebuilding.org>

Dear all

I want to know is there any way to apply this excel function below in trnsys. I want to use this function to control the diverter for my system

=IF(AND(buffertanktoptemp>60,TEStoptemp>60),0.5,IF(buffertanktoptemp>=60,1,0))

Actually I have tried to use GT and LT statement but it doesn't seem to work properly as I want. Can anybody help me?

Thanks

Follow-Ups:
- Re: [TRNSYS-users] "if" function in trnsys
  - From: Jeff Thornton via TRNSYS-users <trnsys-users@lists.onebuilding.org>