| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If error #NUM! or less than 1
Hello:
I have a range of cells that have the possibilties of having either a number, #NUM!, or 0 (zero). I want to use a formula to check if the cell has a number (more than 0), then it should give me that number or else (whether it has a zero value or #NUM!) it should be empty (""). So If I have in C2 the #NUM! and in A1 the folrmula to check if C2 has more than 0, it should stay empty, etc. Thanks for any help. Art |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If error #NUM! or less than 1
Do you mean
=IF(ISERROR(C2),"",IF(C20,C2,"")) If this post helps click Yes --------------- Jacob Skaria "art" wrote: Hello: I have a range of cells that have the possibilties of having either a number, #NUM!, or 0 (zero). I want to use a formula to check if the cell has a number (more than 0), then it should give me that number or else (whether it has a zero value or #NUM!) it should be empty (""). So If I have in C2 the #NUM! and in A1 the folrmula to check if C2 has more than 0, it should stay empty, etc. Thanks for any help. Art |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If error #NUM! or less than 1
Yes. Thanks. I was trying to do it with the OR function, but it didn't work.
Thanks anyways. Art "Jacob Skaria" wrote: Do you mean =IF(ISERROR(C2),"",IF(C20,C2,"")) If this post helps click Yes --------------- Jacob Skaria "art" wrote: Hello: I have a range of cells that have the possibilties of having either a number, #NUM!, or 0 (zero). I want to use a formula to check if the cell has a number (more than 0), then it should give me that number or else (whether it has a zero value or #NUM!) it should be empty (""). So If I have in C2 the #NUM! and in A1 the folrmula to check if C2 has more than 0, it should stay empty, etc. Thanks for any help. Art |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If error #NUM! or less than 1
With OR when you check the condition IF =0 it returns error..
-- If this post helps click Yes --------------- Jacob Skaria "art" wrote: Yes. Thanks. I was trying to do it with the OR function, but it didn't work. Thanks anyways. Art "Jacob Skaria" wrote: Do you mean =IF(ISERROR(C2),"",IF(C20,C2,"")) If this post helps click Yes --------------- Jacob Skaria "art" wrote: Hello: I have a range of cells that have the possibilties of having either a number, #NUM!, or 0 (zero). I want to use a formula to check if the cell has a number (more than 0), then it should give me that number or else (whether it has a zero value or #NUM!) it should be empty (""). So If I have in C2 the #NUM! and in A1 the folrmula to check if C2 has more than 0, it should stay empty, etc. Thanks for any help. Art |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
| Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) | |||
Linear Mode
