| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"If" Formula Error
Below is the formula I currently have. I want to get a "1" if the logical
test answer returns a number not equal to 2-16 (a range). So if the number is less than 2 or greater than 16, I need a 1, otherwise I need "Assign Division". How do you put "not equal" in a formula and how do you put "not equal" to a range of numbers? =IF(MID(D26,2,2)<216,1,"Assign Division") Thanks in advance for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Document not saved" "error in loading DLL" | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) | |||
| VBA setting formula for a cell causes "Wrong data type" error | Excel Discussion (Misc queries) | |||
| How do I replace "#N/A" error, to continue my formula w/o error? | Excel Worksheet Functions | |||
Threaded Mode
