<,> formula

J

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.
 
A

arno

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.
Click to expand...

=IF(AND(A1<24,A1>23),"yes","oh no")

arno
 
P

Peo Sjoblom

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")
 
B

bj

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
 
H

Harlan Grove

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")
Click to expand...
....

Variation on the theme.
 
Top