|  | Check if a number is within a certain range | | |
| | | Guest |  |
|  Posted: Thu Jul 17, 2008 1:20 pm Post subject: Check if a number is within a certain range |  |
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 | |
| | Posted: Thu Jul 17, 2008 1:20 pm Post subject: Re: Check if a number is within a certain range | |
=IF(AND(B7>=0.1%,B7<10%),1,2)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
<ainese@gmail.com> wrote in message
news:3082da2f-eef2-4a5f-9dfa-e27d348595b3@c58g2000hsc.googlegroups.com...
| Quote: | 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?
|
|
| |
| | | Craig Schiller | |
| | Posted: Thu Jul 17, 2008 2:46 pm Post subject: Re: Check if a number is within a certain range | |
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.
ainese@gmail.com wrote:
| Quote: | 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-e27d348595b3@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 :(
|
|
| |
| | | Don Guillett | |
| | Posted: Thu Jul 17, 2008 2:51 pm Post subject: Re: Check if a number is within a certain range | |
Where is the formula that gives a result of 9%. Is is rounding? Post your
data
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
<ainese@gmail.com> wrote in message
news:db3e1428-6c16-4cff-a4d2-3097115cb21c@m3g2000hsc.googlegroups.com...
| Quote: | 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-e27d348595b3@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  |
|
| |
| | | Guest | |
| | Posted: Thu Jul 17, 2008 3:03 pm Post subject: Re: Check if a number is within a certain range | |
On 17 Jul, 15:20, "Don Guillett" <dguille...@austin.rr.com> wrote:
| Quote: | =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-e27d348595b3@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 |
| |
|
|
