|Subject:||Check if a number is within a certain range|
|Date:||Thu, 17 Jul 2008|
I'm trying to check if a number is within a certain range.
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?