Between symbol

  • Thread starter Thread starter chard9401
  • Start date Start date
C

chard9401

Is there a between symbol?

Example:

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

There's no 'between' symbol in Excel
 
=IF(AND(A1>3,A1<5),A1,"")

That is SO bizarre. It's a shame we can't use algebraic syntax: a > b > c
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Greater Than Symbols and calculations 0
Excel Add ^ to a row of cells containing letters 3
Notation Bugs 8
If(cell) "contains" certain words... 2
VBA Question 9
How to make a new currency symbol 5
vba macro that allows insertion of symbols at cursor 0
Symbol in front of Text - Reg 2

Back
Top