Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#VALUE! & find()
hello, what is the value of the cell if there's #VALUE!. I want to use
conditional if, if cell is #VALUE! then 0. from the formula find("d",A2) i get some value and #VALUE!, if there's "d" so the value is the number position of the "d", if there's "d" so the value is #VALUE!. If the cell contains #VALUE!, the next formula is also #VALUE! so if there's value of #VALUE!, I can change the #VALUE! into 0. thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
#VALUE! & find()
teh value of such a cell is ERROR. supose that cell is A1. in b1 type =IF(ISERROR(A1),"no","yes") and see what happens ================================== "bc4n" wrote: hello, what is the value of the cell if there's #VALUE!. I want to use conditional if, if cell is #VALUE! then 0. from the formula find("d",A2) i get some value and #VALUE!, if there's "d" so the value is the number position of the "d", if there's "d" so the value is #VALUE!. If the cell contains #VALUE!, the next formula is also #VALUE! so if there's value of #VALUE!, I can change the #VALUE! into 0. thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
#VALUE! & find()
"venkat" wrote in message
... "bc4n" wrote: hello, what is the value of the cell if there's #VALUE!. I want to use conditional if, if cell is #VALUE! then 0. from the formula find("d",A2) i get some value and #VALUE!, if there's "d" so the value is the number position of the "d", if there's "d" so the value is #VALUE!. If the cell contains #VALUE!, the next formula is also #VALUE! so if there's value of #VALUE!, I can change the #VALUE! into 0. teh value of such a cell is ERROR. supose that cell is A1. in b1 type =IF(ISERROR(A1),"no","yes") and see what happens ================================== You can be more specific with the Error Type, to distinguish #VALUE from other errors such as #DIV/0 or #N/A. =IF(ERROR.TYPE(A1)=3,"Error type is Value","False") -- David Biddulph |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
#VALUE! & find()
thank you for your answer, actually the cell is contain error value and a
value, so if I use =IF(ERROR.TYPE(A1)=3,"Error type is Value","False") the return value if the cell contain a value isn't "False" but #N/A! so I can't use this. But if we use =IF(ISERROR(A1),"no","yes") the return value if the cell contain ada value is "yes" Thank you for both of the answer, It's help my work. "David Biddulph" wrote: "venkat" wrote in message ... "bc4n" wrote: hello, what is the value of the cell if there's #VALUE!. I want to use conditional if, if cell is #VALUE! then 0. from the formula find("d",A2) i get some value and #VALUE!, if there's "d" so the value is the number position of the "d", if there's "d" so the value is #VALUE!. If the cell contains #VALUE!, the next formula is also #VALUE! so if there's value of #VALUE!, I can change the #VALUE! into 0. teh value of such a cell is ERROR. supose that cell is A1. in b1 type =IF(ISERROR(A1),"no","yes") and see what happens ================================== You can be more specific with the Error Type, to distinguish #VALUE from other errors such as #DIV/0 or #N/A. =IF(ERROR.TYPE(A1)=3,"Error type is Value","False") -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Function | Excel Discussion (Misc queries) | |||
Find and Replace | Excel Worksheet Functions | |||
Code needed to find records from bottom up | Excel Discussion (Misc queries) | |||
find a cells from a range of cell | Excel Worksheet Functions | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |