Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Between function
Is there a function in Excel that will determine whether a cell value is
between x and y? I can't find one. I'd like to write an "IF" formula that returns a certain result if the value is between 1 and 100 and a different result if it isn't. Please let me know the proper syntax of the "Between" function if you can. |
#2
|
|||
|
|||
Well, sort of... it's not a dedicated 'between' function, but this is how:
=IF(AND(B11, B1<100), TrueValueHere, FalseValueHere) where B1 is the cell you're looking at. You probably want it to be inclusive of the 1 and 100, so it might need to be like this: =IF(AND(B1=1, B1<=100), TrueValueHere, FalseValueHere) X_HOBBES "Excel GuRu" wrote in message ... Is there a function in Excel that will determine whether a cell value is between x and y? I can't find one. I'd like to write an "IF" formula that returns a certain result if the value is between 1 and 100 and a different result if it isn't. Please let me know the proper syntax of the "Between" function if you can. |
#3
|
|||
|
|||
=if(and(a1=1, a1<=10),"good response","bad response")
"Excel GuRu" wrote: Is there a function in Excel that will determine whether a cell value is between x and y? I can't find one. I'd like to write an "IF" formula that returns a certain result if the value is between 1 and 100 and a different result if it isn't. Please let me know the proper syntax of the "Between" function if you can. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions |