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.

 

[Angela]

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

 

[Angela]

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

Angela