Using and IF formula for a cell value between two amounts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to be able to use a formula to return a true/false value, when a cell value is between two amounts

Eg, if(a6 is between 0.00 and 0.10,"Yes","No")

I can do: if(a6<0.10,"Yes","No"), and if(a6>0.10,"Yes","No"), but not if it's BETWEEN the range specified

It seems like a fairly simple thing to do, and must be a commonly used function, but I can't find out how to do it!

Please please help before I go insane!
 
=IF(AND(A6>0,A6<0.1),"yes","no")
-
HTH. Best wishes Harald
Followup to newsgroup only please

Jen said:
I want to be able to use a formula to return a true/false value, when a
Click to expand...
cell value is between two amounts.
Eg, if(a6 is between 0.00 and 0.10,"Yes","No").

I can do: if(a6<0.10,"Yes","No"), and if(a6>0.10,"Yes","No"), but not if
Click to expand...
it's BETWEEN the range specified?
It seems like a fairly simple thing to do, and must be a commonly used
Click to expand...
function, but I can't find out how to do it!!
 
Hi

Try using the AND function

=If(And(a6>first amount, A6<second amount),"True", "False")

Something like that should work

HTH
-----Original Message-----
I want to be able to use a formula to return a true/false
Click to expand...
value, when a cell value is between two amounts.
Eg, if(a6 is between 0.00 and 0.10,"Yes","No").

I can do: if(a6<0.10,"Yes","No"), and if
Click to expand...
(a6>0.10,"Yes","No"), but not if it's BETWEEN the range
specified?
It seems like a fairly simple thing to do, and must be a
Click to expand...
commonly used function, but I can't find out how to do it!!
 
If you want True/False results then simplify to
=AND(A6>0,A6<0.1)
then the results will be "real" TRUE / FALSE, and not text that states True
/ False.
 
=IF(AND(A1>0;A1<0,1);"True";"False"

=IF(AND(A1>0;A1<0,1);1;0

----- Jen je napisal(a): ----

I want to be able to use a formula to return a true/false value, when a cell value is between two amounts

Eg, if(a6 is between 0.00 and 0.10,"Yes","No")

I can do: if(a6<0.10,"Yes","No"), and if(a6>0.10,"Yes","No"), but not if it's BETWEEN the range specified

It seems like a fairly simple thing to do, and must be a commonly used function, but I can't find out how to do it!

Please please help before I go insane!
 
Back
Top