Function help required... Between funtion

[Angela]

Hello,

I have below formula to calculate wether a number exists between a
start & end serial number.

Start = cell A3
End = cell B3

test value = cell F3

=IF(AND(F3>=A3,F3<=B3),"Yes",IF(AND(F3<=A3,F3>=B3),"Yes","No"))


I want to convert this formula into a function which I can use in
excel/access.

Hope someone can help based on provided formula working.

Thanks.

 

[Ron Rosenfeld]

Hello,

I have below formula to calculate wether a number exists between a
start & end serial number.

Start = cell A3
End = cell B3

test value = cell F3

=IF(AND(F3>=A3,F3<=B3),"Yes",IF(AND(F3<=A3,F3>=B3),"Yes","No"))


I want to convert this formula into a function which I can use in
excel/access.

Hope someone can help based on provided formula working.

Thanks.

=IF(AND(F3>=A3,F3<=B3),"Yes","No")

 

[Angela]

Thanks but I need to have a function like =Between(Number,start,end)
which can give this... just like built-in excel function.

 

[Ron Rosenfeld]

Thanks but I need to have a function like =Between(Number,start,end)
which can give this... just like built-in excel function.

To enter this User Defined Function (UDF), <alt-F11> opens
the Visual Basic Editor. Ensure your project is highlighted
in the Project Explorer window. Then, from the top menu,
select Insert/Module and paste the code below into the
window that opens.

=========================
Option Explicit
Function Between(Number As Double, Bound1 As Double, Bound2 As Double)
As Boolean
Dim LowerLimit As Double
Dim UpperLimit As Double
LowerLimit = IIf(Bound1 <= Bound2, Bound1, Bound2)
UpperLimit = IIf(Bound1 >= Bound2, Bound1, Bound2)
Between = Number >= LowerLimit And Number <= UpperLimit
End Function
===============================

 

[Angela]

Many many thanks for this..
Worked like a charm.

Angela

 

[Ron Rosenfeld]

Many many thanks for this..
Worked like a charm.

Angela

Glad to help. Thanks for the feedback.