greater than but less than

A

Aaron

Hello, im trying to get a if or countif formula to return a value if the
selected cell has a value of between two numbers, ie count if B3 is >10 but
<20. Sounds easy and probibly is but damned if i can get it to work.
Anyone?
 
D

Daniel

Hello,

if the B3 is >=2 but <9 then 1, but if the B3 is >=9 but <15 then 2, and so
on. How would the formula look like?

thank for your reply in advance!
--
Daniel from Poland


T. Valko said:
Try this:

=IF(AND(B3>10,B3<20),return_value_if_true,return_value_if_false)

Biff
Click to expand...
 
D

David Biddulph

IF(B3<2,"undefined",IF(B3<9,1,IF(B3<15,2,"again undefined")))
--
David Biddulph

Daniel said:
Hello,

if the B3 is >=2 but <9 then 1, but if the B3 is >=9 but <15 then 2, and
so
on. How would the formula look like?

thank for your reply in advance!
Click to expand...
 
J

JimAZ

Aaron said:
Hello, im trying to get a if or countif formula to return a value if the
selected cell has a value of between two numbers, ie count if B3 is >10 but
<20. Sounds easy and probibly is but damned if i can get it to work.
Anyone?
Click to expand...
 
J

JimAZ

Aaron said:
Hello, im trying to get a if or countif formula to return a value if the
selected cell has a value of between two numbers, ie count if B3 is >10 but
<20. Sounds easy and probibly is but damned if i can get it to work.
Anyone?
Click to expand...

=IF(AND(B1>10,B1<20),"COUNT",0)
Think this will do it.
Jim
 
Top