If

[Pivotrend]

is there a way in Excel like the If command
where i choose two numbers & if the number im targeting fall betwee
the numbers i choose it will say 1 if not 0

ie:
A1= 5.98
& i want Cell B1 to tell me If those 2 Numbers fall in between 10 & -1



than

 

[Frank Kabel]

Hi
not sure what you second number is but you may try the following in B1
=IF(AND(A1<10,A1>-10),"in between","outside range")

 

[Andy B]

Hi

Try
=IF(AND(A1<10,A1>-10),1,0)

Andy

 

[Harald Staff]

Another:
=ABS(A1)<10

 

[Pivotrend]

thanx all guys

Harald Staff you the ma