Search - InfoPath Dev Sign in | Join | Help 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 Search More Search Options Page 1 of 1 (3 items) Re: Calculated values from Yes/No decisions Hello, I am also doing the same project, in which if we choose N/A, the value of that will distribute to other parameters. Is there a way wherein we can covert this excel formula to Infopath? =IFERROR(SUM(J16:J37)/(100-(SUMIF(E16:E37,"N/A",D16:D37))),0) J16:J37 = sum of the points 100 = default E16:E37 = counting of how many ... Posted to General (Forum) by KadeshaAsejo on 11-15-2021 Re: InfoPath 2013 Hi Hilary, Thank you very much for replying. I wanted to distribute the value of "N/A" in other parameters if I choose "N/A" in the drop down. :) I attached my sample file. :) Posted to General (Forum) by KadeshaAsejo on 04-30-2021 InfoPath 2013 Hello, I need help, as I am doing a project via InfoPath 2013 for parameter scores. Wherein I have 5 drop down list with Yes, No, Half, N/A with scores in it. I would like to to: If I am going to choose N/A, the weight of the score (for example 8), the score will be distributed to all parameters. I tried to do the sum(eval....but it is not ... Posted to General (Forum) by KadeshaAsejo on 04-29-2021 Page 1 of 1 (3 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.