Check if a number is within a certain range

Giganews Newsgroups
Subject: Check if a number is within a certain range
Posted by:  aineā€¦@gmail.com
Date: Thu, 17 Jul 2008

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?

Replies