Between Symbol

[chard9401]

Is there a between symbol I could use?

Example

IF(A1 is between 1 and 5,A1,"")

I need something which will display a result if A1 = a number between 1
and 5

 

[kraljb]

You can use the following

=IF(AND(A1<5,A1>1),A1,"")

 

[Frank Kabel]

Hi
see your other post