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:  aine…@gmail.com
Date: Thu, 17 Jul 2008

On 17 Jul, 15:20, "Don Guillett" <dguille.…@austin.rr.com> wrote:
> =IF(AND(B7>=0.1%,B7<10%),1,2)
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille.…@austin.rr.com<ain.…@gmail.com> wrote in message
>
> news:3082da2f-eef2-4a5f-9dfa-e27d348595…@c58g2000hsc.googlegroups.com...
>
> > Hi
>
> > I'm trying tocheckif a number is within a certainrange.
>
> > EG:
> > say i get a result of 9% in a cell, and in the next cell i want to
> >checkif that falls between therangeof 0.1% and 10% and if it does
> > then apply a formula how do i do this?
>
> > Anyone know please?

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

Replies

In response to

Re: Check if a number is within a certain range posted by Don Guillett on Thu, 17 Jul 2008