Between Function

[MO]

Hi,

I am not quite sure who this will work in excel, but is
there anyway of stating an in between numbers i.e. look
for a number between 10 and 20 IF between this numbers
then output the number if not then output zero.

Cheers

M

 

[Frank Kabel]

Hi
one way:
=IF(AND(A1>=10,A1<=20),A1,0)
where A1 stores your number
HTH
Frank

 

[Guest]

Hi Frank,

Thanks for your help, just what i was looking for.