is there a between formula?

[gjjh25]

I am trying to right a calculation and i want it to be between 0.625 and 0.895, which looks at A1.

So if A1 is between those figure i want it to return a value of one, if it is not I want a zero.

What formula do i need for this?


Thank You

Graham

[arthurbr]

Try =and(A1>0.625,A1<0.895)

[gjjh25]

Thanks that sort of works, though it returns TRUE or FALSE i need it to be 1 or 0.

how can i get it to do that?

[arthurbr]

Sorry

= --and(A1>0.625,A1<0.895)

[gjjh25]

Thanks That works

Graham