Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Add a BETWEEN function & operator

The BETWEEN function is in Microsoft Access, it should also be in Excel. And one could use the operator >< to represent it. So you would have:

=15>A1<25 or =BETWEEN(A1,15,25)
="A">A1<"C" or BETWEEN(A1,"D","L")
=DATE(2020,1,1)>A1<DATE(2020,4,5) or BETWEEN(A1,DATE(2020,1,1)DATE(2020,4,5))

wildcard (*, ?, and ~) could be applied:

="D">A1<"L??" or BETWEEN(A1,"D","L??")

Use the same definition of BETWEEN as MS Access.

15 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Shane Devenshire shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base