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…)
Password icon
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…)
Password icon
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base