Newbie Questionshttps://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)Re: How to change the operation in a formula based on a field selectionhttps://www.infopathdev.com:443/forums/thread/91821.aspxThu, 01 Aug 2013 03:09:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:91821donstephen0https://www.infopathdev.com:443/forums/thread/91821.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=91821<p>Hi Joe920,</p> <p>One solution I can think of is by creating two hidden fields with different operations that runs and sets&nbsp;another field&nbsp;to show a result if a certain condition has been met. </p> <p>Example:</p> <p>field A + field B =&nbsp;<strong>field E</strong></p> <p>field C contains the formula A + B<br />field D contains the formula A&nbsp;- B</p> <p><strong>Rule 1:</strong> <br />Condition: if field B &gt; X<br />Action: Set field E to the value of C.</p> <p><strong>Rule 2:<br /></strong>Condition: if field B &lt; X<br />Action: Set field E to the value of D.</p>How to change the operation in a formula based on a field selectionhttps://www.infopathdev.com:443/forums/thread/91789.aspxTue, 30 Jul 2013 20:46:50 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:91789Joe9200https://www.infopathdev.com:443/forums/thread/91789.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=91789I started out with a simple formula to add to fields in my InfoPath form;<br /><br />(CurrentDriveCapacity) + (CapacitytoAdd)<br /><br />How can I change the operation of adding the two fields to subtracting one from the other based on a setting of another field?