between numbers formula

[Pivotrend]

hello

i have the number 45.12 in A1
& the number 45.20 in A2
& 45.18 in C1

i want a formula that gives me "1" if the number in C1 is between the numbers in A1 & A2 & gives "0" if not

thank you

[daddylonglegs]

Try

=(C1>=A1)*(C1<=A2)

[Pivotrend]

thanx

& if i wanted it to show nothing ""
if not between the numbers what do i use ?

[daddylonglegs]

Try

=IF(AND(C1>=A1,C1<=A2),1,"")

[Pivotrend]

thank you.