Check if a number is within a certain range

[ainese]

Hi

I'm trying to check if a number is within a certain range.

EG:
say i get a result of 9% in a cell, and in the next cell i want to
check if that falls between the range of 0.1% and 10% and if it does
then apply a formula how do i do this?

Anyone know please?

 

[Don Guillett]

=IF(AND(B7>=0.1%,B7<10%),1,2)

 

[ainese]

=IF(AND(B7>=0.1%,B7<10%),1,2)

Hi there
Thanks for that, but i've tried that but it keeps throwing back 2
which isn't what i'm looking for

 

[Craig Schiller]

Where Don has 1, substitute what you want to happen if the conditions
are true. Where Don has 2, substitute what you want to happen if the
conditions are false.

 

[Don Guillett]

Where is the formula that gives a result of 9%. Is is rounding? Post your
data