Between symbol

[chard9401]

Is there a between symbol?

Example:

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

 

[Frank Kabel]

Hi
use
=IF(AND(A1>3,A1<5),A1,"")

There's no 'between' symbol in Excel

 

[Mike Labosh]

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

That is SO bizarre. It's a shame we can't use algebraic syntax: a > b > c