# Another RB IF statement question

**Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9)
**Created:** 2000-08-15 09:04 UTC
**Views:** 388
**Replies:** 1
**URL:** https://www.epiusers.help/t/another-rb-if-statement-question/783

---

## Post #1 by @system

<div id="ygrps-yiv-1409881391">Wendy, not sure why you want to do this but try this formula<br/>
<br/>
IIF( IN-RANGE(PODetail.POLine, 1, 1000) AND MiscCode= &#39;FR&#39;,<br/>
STRING(PODetail.POLine,&#39;&gt;&gt;&gt;&gt;9&#39;), &#39;&#39;)<br/>
<br/>
Regards<br/>
Jim Stetter<br/>
<br/>
  -----Original Message-----<br/>
  From: Wendy Pursche [mailto:<a rel="nofollow" target="_blank" href="mailto:wpursche@...">wpursche@...</a>]<br/>
  Sent: Tuesday, August 15, 2000 7:33 AM<br/>
  To: Vantage egroups list<br/>
  Subject: [Vantage] Another RB IF statement question<br/>
<br/>
<br/>
  Another question for you RB gurus.  I would like my PO Line field to look<br/>
for the range between 1-1000 and display what it finds.  I have written the<br/>
IF statement the way I thought it would work, but of course it doesn&#39;t.<br/>
Ideas??<br/>
<br/>
                                                IIF(PODetail.POLine =<br/>
NUM-ENTRIES(&#39;1&#39;,&#39;1000&#39;) And MiscCode = &#39;FR&#39;, &#39;&#39;,<br/>
STRING(PODetail.POLine,&#39;&gt;&gt;&gt;&gt;9&#39;))<br/>
<br/>
  Thanks!<br/>
<br/>
  Wendy Pursche<br/>
  Network Administrator<br/>
  Schmald Tool & Die, Inc.<br/>
  (810) 743-1600 ext.323<br/>
  <a rel="nofollow" target="_blank" href="mailto:wpursche@...">wpursche@...</a><br/>
<br/>
<br/>
<br/>
[Non-text portions of this message have been removed]</div>

---

## Post #2 by @system

<div id="ygrps-yiv-1275927680">Another question for you RB gurus.  I would like my PO Line field to look for the range between 1-1000 and display what it finds.  I have written the IF statement the way I thought it would work, but of course it doesn&#39;t.  Ideas??<br/>
<br/>
                                              IIF(PODetail.POLine = NUM-ENTRIES(&#39;1&#39;,&#39;1000&#39;) And MiscCode = &#39;FR&#39;, &#39;&#39;, STRING(PODetail.POLine,&#39;&gt;&gt;&gt;&gt;9&#39;))<br/>
<br/>
Thanks!<br/>
<br/>
Wendy Pursche<br/>
Network Administrator<br/>
Schmald Tool & Die, Inc.<br/>
(810) 743-1600 ext.323<br/>
<a rel="nofollow" target="_blank" href="mailto:wpursche@...">wpursche@...</a><br/>
<br/>
<br/>
<br/>
[Non-text portions of this message have been removed]</div>

---


**Canonical:** https://www.epiusers.help/t/another-rb-if-statement-question/783
**Original content:** https://www.epiusers.help/t/another-rb-if-statement-question/783