Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
greater than but less than
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? -- Cheers Aaron |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
greater than but less than
Try this:
=IF(AND(B310,B3<20),return_value_if_true,return_v alue_if_false) Biff "Aaron" wrote in message ... 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? -- Cheers Aaron |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
greater than but less than
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" wrote: Try this: =IF(AND(B310,B3<20),return_value_if_true,return_v alue_if_false) Biff "Aaron" wrote in message ... 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? -- Cheers Aaron |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
greater than but less than
IF(B3<2,"undefined",IF(B3<9,1,IF(B3<15,2,"again undefined")))
-- David Biddulph "Daniel" wrote in message ... 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" wrote: Try this: =IF(AND(B310,B3<20),return_value_if_true,return_v alue_if_false) Biff "Aaron" wrote in message ... 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? -- Cheers Aaron |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
greater than but less than
"Aaron" wrote: 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? -- Cheers Aaron |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
greater than but less than
"Aaron" wrote: 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? -- Cheers Aaron =IF(AND(B110,B1<20),"COUNT",0) Think this will do it. Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have Greater than, I need less than also | Excel Worksheet Functions | |||
if value is greater than # * by 20% if less * by 40 | New Users to Excel | |||
Greater Than but Less than | Excel Worksheet Functions | |||
IF greater than...IF less than....====== | Excel Discussion (Misc queries) | |||
Greater then/less then | Excel Worksheet Functions |