https://community.jmp.com/t5/Discussions/Help-with-JMP-formula-IFERROR/m-p/724132#M90620 <P>My excel formula is: =+IF(AND(E98=1, E108=1), IFERROR(E121-E$128, "NA"), "NA").&nbsp;</P><P>E98 = 1. E108 = 1. E121 is a calculation that came out to .267993337. E128 is a calculation that came out to -0.2792984. How can I re-create that formula in JMP? I'm trying with no success.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="UpliftElk866_0-1707855546427.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/61101i12CC25AA801B28F6/image-size/medium?v=v2&amp;px=400" role="button" title="UpliftElk866_0-1707855546427.png" alt="UpliftElk866_0-1707855546427.png" /></span></P><P>&nbsp;</P> Tue, 13 Feb 2024 20:19:42 GMT UpliftElk866 2024-02-13T20:19:42Z https://community.jmp.com/t5/Discussions/Help-with-JMP-formula-IFERROR/m-p/724132#M90620 <P>My excel formula is: =+IF(AND(E98=1, E108=1), IFERROR(E121-E$128, "NA"), "NA").&nbsp;</P><P>E98 = 1. E108 = 1. E121 is a calculation that came out to .267993337. E128 is a calculation that came out to -0.2792984. How can I re-create that formula in JMP? I'm trying with no success.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="UpliftElk866_0-1707855546427.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/61101i12CC25AA801B28F6/image-size/medium?v=v2&amp;px=400" role="button" title="UpliftElk866_0-1707855546427.png" alt="UpliftElk866_0-1707855546427.png" /></span></P><P>&nbsp;</P> Tue, 13 Feb 2024 20:19:42 GMT https://community.jmp.com/t5/Discussions/Help-with-JMP-formula-IFERROR/m-p/724132#M90620 UpliftElk866 2024-02-13T20:19:42Z