Need help with a formula - InfoPath Dev Sign in | Join | Help in Newbie Questions InfoPath (Entire Site) InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads InfoPath Dev » InfoPath » Newbie Questions » Need help with a formula Need help with a formula Last post 04-30-2019 08:00 AM by Hilary Stoupa. 1 replies. Page 1 of 1 (2 items) Sort Posts: Oldest to newest Newest to oldest Previous Next 04-29-2019 09:14 AM sarah45502 Joined on 04-25-2019 Posts 1 Need help with a formula Reply Contact I'm struggling with how to input an Excel formula into InfoPath. I'm hoping the community can tell me how I can convert it to an InfoPath-friendly formula. The formula is If[Total}<=80, "Contact","Process" 04-30-2019 08:00 AM In reply to Hilary Stoupa Joined on 06-20-2008 Posts 13,297 Re: Need help with a formula Form1.xsn Mark as Not AnswerMark as Answer... Reply Contact You need two rules on your Total field. The first one will have a condition of Total 80 - that will set your target field to Process. I've attached a very simple sample. Save the file locally, right click and select Design. From there you can preview and try it out. Hilary Stoupa Page 1 of 1 (2 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.
I'm struggling with how to input an Excel formula into InfoPath. I'm hoping the community can tell me how I can convert it to an InfoPath-friendly formula.
The formula is If[Total}<=80, "Contact","Process"