Home |
Search |
Today's Posts |
#1
|
|||
|
|||
<,> formula
I am trying to create a formula that says yes when a number is greater than
23 but less than 24 and says no when a number is less than 23 or greater than 24. I can only figure out how to do one or the other but not both. Thank you. |
#2
|
|||
|
|||
Hi Jakefoot,
I am trying to create a formula that says yes when a number is greater than 23 but less than 24 and says no when a number is less than 23 or greater than 24. I can only figure out how to do one or the other but not both. Thank you. =IF(AND(A1<24,A123),"yes","oh no") arno |
#3
|
|||
|
|||
have a look at the AND function
=if(and(a223,a2<24),1,2) -- Don Guillett SalesAid Software "Jakefoot" wrote in message ... I am trying to create a formula that says yes when a number is greater than 23 but less than 24 and says no when a number is less than 23 or greater than 24. I can only figure out how to do one or the other but not both. Thank you. |
#4
|
|||
|
|||
With those conditions then 23 or 24 wouldn't return anything?
Assume that you want greater or equal to 23 and less than or equal 24 as the first condition =IF(AND(A1=23,A1<=24),"Yes","No") -- Regards, Peo Sjoblom "Jakefoot" wrote in message ... I am trying to create a formula that says yes when a number is greater than 23 but less than 24 and says no when a number is less than 23 or greater than 24. I can only figure out how to do one or the other but not both. Thank you. |
#5
|
|||
|
|||
try =if(and(number=23,number<24),"yes","no")
You might have to play with the greater than and less than criteria to get what you want "Jakefoot" wrote: I am trying to create a formula that says yes when a number is greater than 23 but less than 24 and says no when a number is less than 23 or greater than 24. I can only figure out how to do one or the other but not both. Thank you. |
#6
|
|||
|
|||
Peo Sjoblom wrote...
With those conditions then 23 or 24 wouldn't return anything? Assume that you want greater or equal to 23 and less than or equal 24 as the first condition =IF(AND(A1=23,A1<=24),"Yes","No") .... Variation on the theme. =, <=: =IF(ABS(x-23.5)<=0.5,"y","n") , <: =IF(ABS(x-23.5)<0.5,"y","n") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
Dynamic (?) formula | Excel Worksheet Functions | |||
Polynimial trandline formula | Charts and Charting in Excel | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |