Re: Check if a number is within a certain range

Giganews Newsgroups
Subject: Re: Check if a number is within a certain range
Posted by:  Don Guillett (dguillet…@austin.rr.com)
Date: Thu, 17 Jul 2008

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillet…@austin.rr.com
<aine…@gmail.com> wrote in message
news:3082da2f-eef2-4a5f-9dfa-e27d348595…@c58g2000hsc.googlegroups.com...
> 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

In response to

Check if a number is within a certain range posted by aine…@gmail.com on Thu, 17 Jul 2008