Is there a between function?

[baillieston]

I have a number in column A
In column B I have the number 10
In column C I have the number 12

I would like a formula in column D that said
If column A is between the numbers in colums b & C show OK
If not show False

If the number in A was either 10 , 11 , 12 then OK
else False.
Thanks for any help

 

[Jon von der Heyden]

Hi,

Something like:

=IF(AND(A1>=B1,A1<=C1),"Ok","False")

 

[Richie(UK)]

Hi b,

Try this formula in D1:

=IF(AND(A1>=B1,A1<=C1),"OK","False")

HTH

 

[baillieston]

Sorry,
These all work when I do exactly as I said BUT I failed to mention that my values in each of the 3 colums are the result of a formula

When I try it with the formula in colums A,b,c the statement does not seem to give the correct answer?

Is there something else that I need to add?

Thanks again