| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
#REF or #N/A with "IF" formula
Hi,
you asked "how come...." The reason is because "N/A" which you enterd is a text entry and what Excel is returning when you see #N/A is an error value, not text. This is true for all 7 errors that Excel displays such as NAME?, VALUE# and #REF! You can trap these types of errors, depending on which one, using ISERR ISNA ISERROR and you can determine which one it is by using ERROR.TYPE You should look each of these up in the Help system to understand what the differences are and what the return value is from the last one. -- Thanks, Shane Devenshire "F. Lawrence Kulchar" wrote: FLKulchar In cell A1, I have either #N/A or #REF because, there 'was' an error in my formula! How come...=IF(A1="N/A", 3,4) does NOT work? How can I make it to work...in other words, if cell A1 has a #N/A in it, how can I make the 'IF' formula work??? Same is true for the "#REF" error!! Please help. FLKulchar |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| conditional formula to show "open" or "closed" | Excel Worksheet Functions | |||
Threaded Mode
