How to use a complex range in a complex IF statement

[novice2]

I have a range to be used in the first IF statement
assetnum between 85000 and 85999
assetnum between 88000 and 88900
and assetnum = 87500

if these above ranges occur then the 2nd IF statement

if(RS("Expense&quot.value){
Response.Write(rightAlign(setDecimals(RS("ActExp&quot.value.toString(), 0), "na&quot + " "

would display "na".

if the above ranges does not occur then the statement

if(RS("Expense&quot.value){
Response.Write(rightAlign(setDecimals(RS("ActExp&quot.value.toString(), 0), colAct) + " "
would display the actual value of the expense.

The code as mentioned below works fine for only one number. please help me with this nightmare. Thanks.

Actual code

if(RS("AssetNum&quot.value != "87500&quot{

if(RS("Expense&quot.value){
Response.Write(rightAlign(setDecimals(RS("ActExp&quot.value.toString(), 0), colAct) + " "
Response.Write(rightAlign(setDecimals(RS("PLExp&quot.value.toString(), 0), colPlan) + " "
}else{
Response.Write(rightAlign("" + setDecimals(RS("ActUnits&quot.value.toString(), 0), colAct) + " "
Response.Write(rightAlign("" + setDecimals(RS("PLUnits&quot.value.toString(), 0), colPlan) + " "
}
}else{
if(RS("Expense&quot.value) {
Response.Write(rightAlign(setDecimals(RS("ActExp&quot.value.toString(), 0), "na&quot + " "
Response.Write(rightAlign(setDecimals(RS("PLExp&quot.value.toString(), 0), "na&quot + " "
}else{
Response.Write(rightAlign("" + setDecimals(RS("ActUnits&quot.value.toString(), 0), "na&quot + " "
Response.Write(rightAlign("" + setDecimals(RS("PLUnits&quot.value.toString(), 0), "na&quot + " "
}
}

 

[smbure]

Wouldn't it be (if all conditions were and):

if((RS(&quot;AssetNum&quot.value = &quot;87500&quot && (RS(&quot;AssetNum&quot.value >= &quot;88800&quot; && RS(&quot;AssetNum&quot.value <= &quot;88900&quot && (RS(&quot;AssetNum&quot.value >= &quot;85000&quot; && RS(&quot;AssetNum&quot.value <= &quot;85999&quot){

//do stuff

} gettin' jiggy wid' it --
smbure

 

[smbure]

Actually...they need to be OR, sorry

if((RS(&quot;AssetNum&quot.value = &quot;87500&quot || (RS(&quot;AssetNum&quot.value >= &quot;88800&quot; && RS(&quot;AssetNum&quot.value <= &quot;88900&quot || (RS(&quot;AssetNum&quot.value >= &quot;85000&quot; && RS(&quot;AssetNum&quot.value <= &quot;85999&quot){

//do stuff

} gettin' jiggy wid' it --
smbure