topic Help with an IF() statement? in Discussions https://community.jmp.com/t5/Discussions/Help-with-an-IF-statement/m-p/5802#M5801 <HTML><HEAD></HEAD><BODY><P> I would like to use an IF() statement to assign a value to a column if another column meets a certain requirement.</P><P></P><TABLE border="1" class="jiveBorder" height="144" jive-data-cell="{&quot;color&quot;:&quot;#000000&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;}" jive-data-header="{&quot;color&quot;:&quot;#ffffff&quot;,&quot;backgroundColor&quot;:&quot;#6690bc&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;fontFamily&quot;:&quot;Arial&quot;}" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 183px; HEIGHT: 50px; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Column 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Column 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">UNKNOWN</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>D = 100;</P><P></P><P>IF( :Column 1 == "UNKNOWN", :Column 2 = D);</P><P></P><P>The script isn't recognizing D as the value "100". Could anyone help me out?</P></BODY></HTML> Fri, 19 Oct 2012 14:47:39 GMT hacketkm 2012-10-19T14:47:39Z Help with an IF() statement? https://community.jmp.com/t5/Discussions/Help-with-an-IF-statement/m-p/5802#M5801 <HTML><HEAD></HEAD><BODY><P> I would like to use an IF() statement to assign a value to a column if another column meets a certain requirement.</P><P></P><TABLE border="1" class="jiveBorder" height="144" jive-data-cell="{&quot;color&quot;:&quot;#000000&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;2&quot;}" jive-data-header="{&quot;color&quot;:&quot;#ffffff&quot;,&quot;backgroundColor&quot;:&quot;#6690bc&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;,&quot;fontFamily&quot;:&quot;Arial&quot;}" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 183px; HEIGHT: 50px; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Column 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"><STRONG>Column 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;"></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">UNKNOWN</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>D = 100;</P><P></P><P>IF( :Column 1 == "UNKNOWN", :Column 2 = D);</P><P></P><P>The script isn't recognizing D as the value "100". Could anyone help me out?</P></BODY></HTML> Fri, 19 Oct 2012 14:47:39 GMT https://community.jmp.com/t5/Discussions/Help-with-an-IF-statement/m-p/5802#M5801 hacketkm 2012-10-19T14:47:39Z Re: Help with an IF() statement? https://community.jmp.com/t5/Discussions/Help-with-an-IF-statement/m-p/5803#M5802 <HTML><HEAD></HEAD><BODY><P class="MsoNormal"><SPAN style="font-size: 10pt; font-family: 'Courier New'; color: black;"><BIG><SPAN style="font-family: Calibri;">You just need to address it by row.</SPAN></BIG></SPAN></P><P class="MsoNormal"><BR /><SPAN style="font-size: 10pt; font-family: 'Courier New'; color: black;">D </SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; color: navy;">=</SPAN><SPAN style="color: teal; font-size: 10pt; font-family: 'Courier New';"><STRONG>100</STRONG></SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; color: navy;">;</SPAN><BR /><SPAN style="font-size: 10pt; font-family: 'Courier New'; color: #0000dd;">for each Row</SPAN><SPAN style="color: black; font-size: 10pt; font-family: 'Courier New';"><STRONG>(</STRONG></SPAN><BR /><SPAN style="font-size: 10pt; font-family: 'Courier New'; color: black;"><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; color: #0000dd;">if</SPAN><SPAN style="color: black; font-size: 10pt; font-family: 'Courier New';"><STRONG>(</STRONG></SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; color: navy;">:</SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; color: purple;">"Column 1"</SPAN><SPAN style="color: black; font-size: 10pt; font-family: 'Courier New';"><STRONG>[]</STRONG></SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; color: navy;">==</SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; color: purple;">"UNKNOWN"</SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; color: navy;">,</SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; color: navy;">:</SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; color: purple;">"Column 2"[] </SPAN><SPAN style="font-size: 10pt; font-family: 'Courier New'; color: navy;">= </SPAN><SPAN style="color: black; font-size: 10pt; font-family: 'Courier New'; font-weight: bold;">D</SPAN><BR /><SPAN style="font-size: 10pt; font-family: 'Courier New'; color: black;"><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><STRONG>)</STRONG><BR /></SPAN><SPAN style="line-height: 115%; color: black; font-size: 10pt; font-family: 'Courier New';"><STRONG>)</STRONG></SPAN></P><P class="MsoNormal"><SPAN style="font-family: Calibri;">The other option is to create a new column with a formula.&nbsp; Then your solution would work.</SPAN></P></BODY></HTML> Fri, 19 Oct 2012 16:53:25 GMT https://community.jmp.com/t5/Discussions/Help-with-an-IF-statement/m-p/5803#M5802 Anonymous 2012-10-19T16:53:25Z