| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another "If" Formula Error
Below is my formula. The formula turns up an error when it finds text instead
of numbers. I would like it to return 1 when it finds text instead of numbers. =IF(OR((0+MID(D42,2,2))*1<2,(0+MID(D42,2,2)16)),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
