Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |