Excel 2010 - get result if cell 'between' certain numbers 1

[dsmith910]

Hi
Am sure I've seen something somewhere which will help!

I want to have a formula which says something like:

if(A1=between15and22,1,0)

i.e. if cell A1 has a value between 15 and 22 then put 1 otherwise 0

Anyone know what I need to do.
Thanks

 

[SkipVought]

hi,
[tt]
=if(and(A1>=15,A1<=22),1,0)
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[dsmith910]

Many thanks - that works just great.