Formula for value betweens cells

[Blackwell]

Hello, I am trying to find a formula for three cells. The first cell A1 £2700. The second cell, A2 £3,142 and the third cell A3 £10428.
If A1 value is between cells A2:A3 then input the value in A4. If not then 0 in A4.
A1 £2,700
A2 £3,142
A3 £10,428
A4 0

A1 £5,400
A2 £3,142
A3 £10,428
A4 £5,400
I hope I have explained ok. Thank you.

 

[James006]

Hi,
You can test for cell A4 following formula

=IF(AND(A1>A2,A1<A3),A1,0)

 

[Blackwell]

Thank you, James 006. It works fine. Much appreciated.