If condition with between ranges

[suriya6in]

Hi

Is there any possibility of giving IF function along with finding data inbetween a particular ranges of values?

ie., if A1 is > 100 but < 200, some logical result else if it is between someother range, next logical result and so on!
if yes, clear syntax pls!!

suriya

 

[bat17]

Yes it can be done, but for a clear syntax it would help if you said where you need to use it! In a Report? in VBA? in a Query?
For a Query you can use nested Iif statements
CheckValue: IIf([id]>2000 And [id]<3000,"2 to 3",IIf([id]>3000 And [id]<4000,"3 to 4","None of the Above"))
If you need to use a lot of options then you may be better off writing a custom function to handle it.

HTH

Peter

 

[suriya6in]

Hi

Yes i need to use it in a query!
But say,

=IF(A1>20 And A1<30,"hi",false)


Is this a correct format? but this gives an error that the formula entered is wrong!!

suriya

 

[bat17]

In a Query you need to use the Immediate If function IIF not IF

HTH


Peter